Get Max and Corresponding Text

Giganews Newsgroups
Subject: Get Max and Corresponding Text
Posted by:  Courtney (courtney.mac…@gmail.com)
Date: Tue, 10 Mar 2009

Hi all,

I have a table that looks something like this:

            A      B      C        D
x          50            150      15
y                  5      50      15
z          50                        4
total    100  5      200    34

I need to be able to find the Max of the total column, and get the
corresponding title (A,B,C,or D) of that maximum number. I then need
to get the 2nd, 3rd, and 4th highest totals, along with their
corresponding heading (A, B, C, D). Can someone tell me which function
I can achieve this with?

Thanks,
C

Replies