Get max value
Closed
senthilrajagopi
Posts
4
Registration date
Tuesday January 6, 2015
Status
Member
Last seen
January 8, 2015
-
Jan 7, 2015 at 01:11 AM
RayH - Jan 9, 2015 at 10:20 AM
RayH - Jan 9, 2015 at 10:20 AM
Related:
- Get max value
- Free fire max download - Download - Battle royale
- Hbo max download pc - Download - Movies, series and TV
- Free fire max email id - Guide
- Max repel cheat code fire red - Guide
- Max active checking torrents - Guide
3 responses
Not exactly what you wanted but its close:
=IF(A2=0,0,MAX(IF(A2=$B$2:$B$11,$C$2:$C$11,0)))
This returns the MAX value for the pair.
Enter this formula as an Array formula.
So instead of pressing Enter, press Ctrl-Shift Enter.
This will put curly braces { and } around the formula. drag this formula down the list.
=IF(A2=0,0,MAX(IF(A2=$B$2:$B$11,$C$2:$C$11,0)))
This returns the MAX value for the pair.
Enter this formula as an Array formula.
So instead of pressing Enter, press Ctrl-Shift Enter.
This will put curly braces { and } around the formula. drag this formula down the list.
senthilrajagopi
Posts
4
Registration date
Tuesday January 6, 2015
Status
Member
Last seen
January 8, 2015
Jan 8, 2015 at 01:11 AM
Jan 8, 2015 at 01:11 AM
thanks buddy, i will try and given the feedback ASAP
senthilrajagopi
Posts
4
Registration date
Tuesday January 6, 2015
Status
Member
Last seen
January 8, 2015
Jan 8, 2015 at 01:27 AM
Jan 8, 2015 at 01:27 AM
it's working. but i need one more requirement in this scenario.
if in two cells are equal, in column d duplicate values to be eliminated.
kindly give the ASAP.
if in two cells are equal, in column d duplicate values to be eliminated.
kindly give the ASAP.
Jan 8, 2015 at 03:53 AM
it's working. but i need one more requirement in this scenario.
if in two cells are equal, in column d duplicate values to be eliminated.
Jan 9, 2015 at 10:20 AM