RANK FUNCTION

[Joshua]

how to rank data from 3 location (worksheet or workbook

the data range are same in 3 location. The situation like this; worksheet1 contain record about 25 student and total marks, worksheet2 contain another 25 student and mark, worksheet3 another 25 students with marks. I would like to know who is the best by using rank order from 1st to 75th

 

[Harlan Grove]

how to rank data from 3 location (worksheet or workbook)

the data range are same in 3 location. The situation like this;
worksheet1 contain record about 25 student and total marks,
worksheet2 contain another 25 student and mark, worksheet3
another 25 students with marks. I would like to know who is the
best by using rank order from 1st to 75th.

RANK and COUNTIF (which can simulate RANK) can only be used with single area
ranges from a single worksheet. If you want to use either you must
consolidate your marks onto a single worksheet in a single range. Otherwise,
you'll need to use various formula techniques to consoldate the marks into a
single array. See

http://groups.google.com/[email protected]