try this
Option Base 1
Sub nemi()
Dim s(5) As String
Dim z As Long
s(1) = "Very Good"
s(2) = "Good"
s(3) = "Better"
s(4) = "Bad"
s(5) = "Very Bad"
For i = 1 To 5
On Error Resume Next
Sheets(1).ShowAllData
z = Sheets(1).Range("f65356").End(xlUp).Row + 1
Sheets(1).Range("$A$3:$e$" &
Sheets(1).Ra
hi Nemi Gandhi
use this formula in cell F4 of your table and than sort it by column F
shortest to largestyou will table as per your need
*=IF(E4="Very Good",1,IF(E4="Good",2,IF(E4="Better",3,IF(E4="Bad",4,5*
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'
Formula needed please.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http:/
