Return MAX valueClosed

Question

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,

Configuration: Windows Vista / Internet Explorer 7.0

TrowaD · Answer

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 ...???

RayH · Answer

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?

curtezanu · Answer

If possible, both of them.

TrowaD · Answer

Sorry dude, can't come up with an answer for you.

Hopefully some else will provide an answer.

Return MAX value

4 responses

Similar discussions

Subscribe To Our Newsletter!