order wise match with batch and qty : I have a problem with excel sheet. i am sharing you my excel problem.
Col-A       Col-B  Col-C
Order.No	Batch	Qty
123451	     211	5
123451	     212	30
123451	     213	50
123461	     311	40
123471	     411	50
123471	     511	80
123481	     611	20
123491	     612	30

in col-A 123451 is repeating 3 time and 123471 2 time. i would like to max value from Col-3 and show batch No in front of it but only match 123451 order no.

like

Order.No     Batch     Qty
123451        213       50
123461	      311	    40
123471	      411	    80
123481	      611	    20
123491	      612	    30

as per this result you can see that Order.No-123451 find max value Qty and paste value batch-No as per maximum value criteria. remove duplicate Order No. the data can more then this. this is just example.

Thanks.

Please share this my Email:
majid_mug@yahoo.com

