Return MAX value

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

i have below data. Can I have a formula that can show me the max number in column 2 for one instance in Column 1 and copy the respective cell in Column 3 corresponding to that maximum value?

Example: A from Column 1 has a max value in Column 2 of "2", corresponding to either Normal Status or Missed Delivery.

Column 1 Column 2 Column 3
A 0 NORMAL STATUS
A 0 SHIPPER RELATED
A 1 NORMAL STATUS
A 0 NORMAL STATUS
A 1 NORMAL STATUS
A 0 NORMAL STATUS
A 0 NORMAL STATUS
A 2 NORMAL STATUS
A 2 MISSED DELIVERY
A 0 MISSED DELIVERY
A NORMAL STATUS
B 0 NORMAL STATUS
B 0 NORMAL STATUS
B 1 NORMAL STATUS
B 0 NORMAL STATUS
B 3 SHIPPER RELATED
B 1 NORMAL STATUS
B 1 MISSED DELIVERY
B MISSED DELIVERY

thanks,

4 replies

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi curtezanu,

Don't understand you.

You want to find the highest value in column 2, then you want to copy the corresponding data of column 3, then what do want ...???
i want an automated process that can identify the biggest value in column 2 for the same value in column 1. after that, i need the value in column 3 corresponding to the highest value to be highlighted / copied in another column.
A 2 NORMAL STATUS 
A 2 MISSED DELIVERY 


According to your example these two records would be found, which one should be copied, NORMAL or MISSED, or BOTH?
If possible, both of them.
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Sorry dude, can't come up with an answer for you.

Hopefully some else will provide an answer.