Register now or log in to join your professional community.
1 st Week Order Products Order Qty Deliver Qty1034 Iron Aluminium Silver Iron Aluminium Silver6003002nd Week Order Products Order Qty Deliver Qty1034 Iron Aluminium Silver Iron Aluminium Silver600275
In Excel Select Both Columns And Then 1. Click On Conditional Formating
2.Select Highlight Cell Rules
And Select Duplicate Values
as Atif mentioned, question isn't clear. if we have to pick up products from column2 based on the order number in column1, we can use VLOOKUP. or if you are looking for something else, please let me know
question is not clear, will you please give more detail
