Looking for RANK macro
 

Got 4 columns to rank. Next to each column of data is the rank column.S
8 columns in all,alternating with data and rank. There is a header fo
each column. This data to be ranked is imported into Excel.To make
long story short,each time the data is imported into Excel,it will si
in different cells,that’s why I just cant record a macro for it. I’
looking for a macro that will allow the rank columns to rank the dat
adjacent to it, no matter what part of the spreadsheet the data fall
on

--
ligh
-----------------------------------------------------------------------
light's Profile: http://www.excelforum.com/member.php...nfo&userid=722
View this thread: http://www.excelforum.com/showthread.php?threadid=27468