Ranked Lookup

[emanon132501]

Hi,

Please help me create a formula that performs a Lookup based on Rank. In Column B i have a list of Emp ID's and in Column C i have the task code (the order in which the jobs are queued). The output that I'm looking for is to Lookup only the first four Tasks that were done for the day for each Employee.

I have attached a sample file.

Thanks

[Sadath31]

Try this CSE formula
task1 =SMALL(IF($B$4:$B$100=$E5,$C$4:$C$100),1)
task2 =SMALL(IF($B$4:$B$100=$E5,$C$4:$C$100),2)

so on.....

[jeffreybrown]

You can just change the last part of the formula too...

CSE
=SMALL(IF($B$4:$B$100=$E4,$C$4:$C$100),COLUMN(A$1))

...then drag across and down

[emanon132501]

GREAT!!! Thanks a lot sir!

[jeffreybrown]

If you are satisfied with the solution(s) provided, please do not forget to mark the thread as solved.