Finding state that contains employees biggest sale
Array entered:
=INDEX(C1:C4,MATCH(1,(A1:A4="Joe")*(B1:B4=MAX(IF(A 1:A4="Joe",B1:B4))),0))
--
Biff
Microsoft Excel MVP
"Toppers" wrote in message
...
.... no it doesn't!!!
"Toppers" wrote:
one way:
=INDEX($C$1:$C$4,MATCH(MAX(($A$1:$A$4="Joe")*($B$1 :$B$4)),$B$1:$B$4,0))
Enter with Ctrl+Shift+Enter
Substitute "Joe" with cell containing name
"Richard" wrote:
I have data like this
EMPLOYEE SALE STATE
Joe 10.00 PA
Joe 20.00 VA
Sue 5.00 TX
Sue 10.00 WA
For each employee, how do I find the state that corresponds to the
largest
sale. For example, for Joe this would be VA since his largest sale of
20.00
was to VA.
--
Richard
|