Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to match two character in excel (like order no & Products are repeated . how to pickup the value column 2 to 1?

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

user-image
Question added by buhari sherif , Sales Coordinator + IT Support , KHK Scaffolding
Date Posted: 2014/05/24

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

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

question is not clear, will you please give more detail

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.