Hi,
In sample attached, I need to max value of G12:G35 in C3 where A12:35 matches with A3.
Can you please assist in this please
Hi,
In sample attached, I need to max value of G12:G35 in C3 where A12:35 matches with A3.
Can you please assist in this please
Please try at C3
=AGGREGATE(14,6,$G$12:$G$35/($A$12:$A$35=A3),1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks