RANK
I have multiple rows for different cities. I have to rank under each row. For
example : col. d col e col.f col. g col.h col.i col.j row 1 citi name 545 245 345 411 123 579 row 2 rank 5 2 3 4 1 6 row 3 citi name 535 124 345 411 123 579 row 4 rank 5 2 3 4 1 6 and so on about 600 rows with citi names. I have to find out the rank for each city. Is there any formula I can type in for ranks. I have use the formula =rank(e1,e1:j6,1) It works for first row and then next row is showing #n/a. Please help Thanks Jai Is there any formula |
RANK
In E2:
=RANK(E1,$E$1:$J$1,1) and copy across In E5: =RANK(E4,$E$4:$J$4,1) and copy across -- Gary''s Student - gsnu200748 "Jai" wrote: I have multiple rows for different cities. I have to rank under each row. For example : col. d col e col.f col. g col.h col.i col.j row 1 citi name 545 245 345 411 123 579 row 2 rank 5 2 3 4 1 6 row 3 citi name 535 124 345 411 123 579 row 4 rank 5 2 3 4 1 6 and so on about 600 rows with citi names. I have to find out the rank for each city. Is there any formula I can type in for ranks. I have use the formula =rank(e1,e1:j6,1) It works for first row and then next row is showing #n/a. Please help Thanks Jai Is there any formula |
All times are GMT +1. The time now is 12:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com