Max value
Closed
nate
-
11 Feb 2011 à 15:00
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Feb 2011 à 08:56
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Feb 2011 à 08:56
Related:
- Max value
- Max active checking torrents - Guide
- Backslash max - Guide
- Hbo max download pc - Download - Movies, series and TV
- Security antivirus max cleaner - Download - Antivirus
- Max repel cheat code fire red - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
14 Feb 2011 à 08:56
14 Feb 2011 à 08:56
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
