Max value
Closed
nate
-
Feb 11, 2011 at 03:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 14, 2011 at 08:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 14, 2011 at 08:56 AM
Related:
- Max value
- Hbo max download pc - Download - Movies, series and TV
- Sound max - Download - Drivers
- Free fire max download - Download - Battle royale
- Max repel cheat code - Guide
- Airpods max 2 - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 14, 2011 at 08:56 AM
Feb 14, 2011 at 08:56 AM
Hi Nate,
Try this:
=MAX(($A$1:$A$6="POR")*($B$1:$B$6))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter. This will put curly brackets around the formula.
Drag the formula down 2 times and replace the word "POR" by "BAR" and "DAR".
Best regards,
Trowa
Try this:
=MAX(($A$1:$A$6="POR")*($B$1:$B$6))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter. This will put curly brackets around the formula.
Drag the formula down 2 times and replace the word "POR" by "BAR" and "DAR".
Best regards,
Trowa
