Please Help-sorting Data

[mnarvind]

Hi,

Ive got a sorting problem....

the user enters data in a sheet (say 8 rows of data) . I have to choos
the top 3 from that data . for example:

*col a col b col c *

a emp1 41,454
b emp2 256,456
c emp3 116,755
d emp4 (257,000)
e emp5 946,001
f emp6 (244,545)
g emp7 86,242
h emp8 710,200

From this data in "Col C ",I have to choose the top three(startin
from the highest ) separating the negatives from the positives an
display the data in the 3 columns.

It would be enough if I am able to choose the top three positiv
numbers.

Nested ifs are proving to be too difficult to manage after 3 or
numbers.

please help........

thanx in advance,
Arvind

 

[Tom Ogilvy]

Data=>sort, use column 3 as the sort key.

Otherwise, state why you are having problems.

You can also look at the worksheet functions Large, Index, Match, Vlookup,
Lookup, Rank as a start.