Displaying Maximum Values along with the name

[Zaid]

Dear All,

See attached the Excel. I have Category in "Column A" and Amount in "Column B".

Now in Top 3 table i want the top 3 values from the table and same as i want in bottom 3 table. Please suggest a formula for the same.

Regards
Mohammad

[Fotis1991]

Hi

In e2 and copy to e4

=LARGE($B$2:$B$17,ROW(A1))

In D2 and copy to d4

=INDEX($A$2:$A$17,MATCH(E2,$B$2:$B$17,0))

Same way for the SMALL function

=SMALL($B$2:$B$17,ROW(A1))