View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matthew
 
Posts: n/a
Default =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