=MAX-Return Cell info
Yes, you are right...it could be repeated...unlikely...but possible ! Dammit!!
I cant quite get the date formulae to work....could it be because my data is
in the range B241..F267? I can get the name bit right no problem -
{=INDEX($B$241:$F$241,MIN(IF(C242:F267=MAX(C242:F2 67),COLUMN(C242:F267)-1)))}
"Biff" wrote:
I'll await a reply from the OP!
Biff
"Dave Peterson" wrote in message
...
Ooh. Excellent point.
I'll await one of your formulas!
Biff wrote:
What if there are duplicate max values?
Biff
"Matthew" wrote in message
...
Please help all you clever people !!
I have a table in the format:
MR A MR B MR C MR D
01/01/06 1 3 7 8
02/01/06 2 5 4 4
03/01/06 3 9 5 7
I want a formula to analyse the entire table (Which can change) and to
return me who has achieved the Max value and on which date.
The answer here should be MR B on the 03/01/06.
PLEASE HELPPP!!!
--
Dave Peterson
|