Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trouble ranking data...
For some reason I am having trouble ranking a set of numbers.
In this scenario I have a set of random numbers in cells E2 - E133. In cell F2 I type the following =rank(E:E,E:E,1) to rank the data in E. That works fine, but then when I copy F2 and highlight F3 - F133 and then paste it all I get is the F2 result. Now if I go down the column and dbl click each cell the convert to the correct E column data... What am I doing wrong here that my whole column will not rank for me? DO I have something locked or protected?? Thanks in advance. Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
trouble ranking data...
Is there anyone today who can help me maybe?
Minsk wrote: For some reason I am having trouble ranking a set of numbers. In this scenario I have a set of random numbers in cells E2 - E133. In cell F2 I type the following =rank(E:E,E:E,1) to rank the data in E. That works fine, but then when I copy F2 and highlight F3 - F133 and then paste it all I get is the F2 result. Now if I go down the column and dbl click each cell the convert to the correct E column data... What am I doing wrong here that my whole column will not rank for me? DO I have something locked or protected?? Thanks in advance. Bob -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200605/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking Data | Excel Discussion (Misc queries) | |||
Ranking Data | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |