Capture.JPG
Basically I want to take the greater value only from the second column based off of when there is a duplicate within the first column.
Capture.JPG
Basically I want to take the greater value only from the second column based off of when there is a duplicate within the first column.
=if(c2=max(index((b$2:b$12=b2)*(c$2:c$12),0)),c3,"")
Enter the formula in e2 and copy towards down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks