Good Day to All,

[Juniad]

i would like to ask u one problem that i am facing in excel and trying to find the solution but Abortive. Can u help me in this point.
Example:
Column 1 Column 2
Name Value
A 1
B 1
C 2
A 2
C 1
B 3
Just i want to find the name which is having the max value when we count . like in this Example, when manually we calculate the answer it will be B, Because one B has value 1 and second has value 3 so 1+3=4, so answer should be B. I want the answer within single cell

 

[bosco_yip]

Maybe,

1] Assume your data housed in A1:B6

2] In D1, enter formula :

=INDEX(A1:A6,MATCH(AGGREGATE(14,6,SUMIF(A1:A6,A1:A6,B1:B6),1),INDEX(SUMIF(A1:A6,A1:A6,B1:B6),0),0))

Regards
Bosco

 

[Juniad]

Maybe,

1] Assume your data housed in A1:B6

2] In D1, enter formula :

=INDEX(A1:A6,MATCH(AGGREGATE(14,6,SUMIF(A1:A6,A1:A6,B1:B6),1),INDEX(SUMIF(A1:A6,A1:A6,B1:B6),0),0))

Regards
Bosco

Thanks #Bosco a lot.. But unfortunately am using MS Office 2007 .. this is not working on it..
can u help me out

 

[bosco_yip]

Thanks #Bosco a lot.. But unfortunately am using MS Office 2007 .. this is not working on it..
can u help me out

Then, use this array formula (confirmed enter with pressing SHIFT+CTRL+ENTER 3 keystrokes together)

=INDEX(A1:A6,MATCH(MAX(SUMIF(A1:A6,A1:A6,B1:B6)),SUMIF(A1:A6,A1:A6,B1:B6),0))

Regards
Bosco

 

[Juniad]

Then, use this array formula (confirmed enter with pressing SHIFT+CTRL+ENTER 3 keystrokes together)

=INDEX(A1:A6,MATCH(MAX(SUMIF(A1:A6,A1:A6,B1:B6)),SUMIF(A1:A6,A1:A6,B1:B6),0))

Regards
Bosco

U are so cool Bosco... I love u