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 a row in a table in word - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Spell number in excel without macro - Guide
- Html table fit to screen - Guide
- Excel macro to create new sheet based on value in cells - 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