Hi,
I have a list of Team Leaders, Agents, and the agents conversion rate.
The conversion rate is updated daily from telephony reports, and I manually sort it into conversion order each day before sending it round.
What I want to do is find the highest converter for each team.
So:
Column A ('TeamLeader' range) has the Team leaders in, column B has the agent name ('Agent' range), and column F has the agents conversion rate ('conversion' range).
I think I'm on the right track with this formula:
=(MAX(IF(TeamLeader="Bonnie",Conversion))
But this only displays the figure in the Conversion rate, how to I get it to 'step back' 4 column's and show the agents name?
I tried this:
=VLOOKUP(MAX(IF(TeamLeader="Bonnie",Conversion)),A5:F60,-4,FALSE)
but that returns #NA - is this because I'm asking the VLOOKUP to look 'backwards' 4 columns?
Thankyou! Hope this made sense!
I have a list of Team Leaders, Agents, and the agents conversion rate.
The conversion rate is updated daily from telephony reports, and I manually sort it into conversion order each day before sending it round.
What I want to do is find the highest converter for each team.
So:
Column A ('TeamLeader' range) has the Team leaders in, column B has the agent name ('Agent' range), and column F has the agents conversion rate ('conversion' range).
I think I'm on the right track with this formula:
=(MAX(IF(TeamLeader="Bonnie",Conversion))
But this only displays the figure in the Conversion rate, how to I get it to 'step back' 4 column's and show the agents name?
I tried this:
=VLOOKUP(MAX(IF(TeamLeader="Bonnie",Conversion)),A5:F60,-4,FALSE)
but that returns #NA - is this because I'm asking the VLOOKUP to look 'backwards' 4 columns?
Thankyou! Hope this made sense!
Last edited: