Help with %'s

R

rsheppick

Hello all,

I have a question.

I have a bunch of information mostly
names/balances/percentages/interest rates

I need a way to associate a name with the highest % they are always
going to be different.

What I need is for excel to understand to look at a possible group of
percentages and find the highest one and associate that percentage with
the name listed directly to the left of wherever in any given 38
possible lines of percentages.
 
B

Biff

Hi!

What does "associate" mean?

Do you want a formula that returns the name based on the
highest percentage? Maybe something like this:

Names in col A
% in col C

=INDEX(A2:A100,MATCH(MAX(C2:C100),C2:C100,0))

Biff
 
Top