Macro to get the highest value in a table
Closed
francis
-
Aug 3, 2016 at 02:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 4, 2016 at 11:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 4, 2016 at 11:32 AM
Related:
- Macro to get the highest value in a table
- How to delete part of a table in word - Guide
- Back alley table - Download - Adult games
- Ascii table c++ - Guide
- School time table class wise and teacher wise software free - Download - Organisation and teamwork
- Html table fit to screen - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 4, 2016 at 11:32 AM
Aug 4, 2016 at 11:32 AM
Hi Francis,
Put column A and C next to each other, then use Advanced Filter (found under the data tab) to filter on unique values and place in a different location:

Then use the following formula in colmn G:
=MAX(($A$2:$A$16=E2)*($C$2:$C$16) *($B$2:$B$16=F2))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
Best regards,
Trowa
Put column A and C next to each other, then use Advanced Filter (found under the data tab) to filter on unique values and place in a different location:

Then use the following formula in colmn G:
=MAX(($A$2:$A$16=E2)*($C$2:$C$16) *($B$2:$B$16=F2))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
Best regards,
Trowa