Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par buhari sherif , Sales Coordinator + IT Support , KHK Scaffolding
Date de publication: 2014/05/24

In Excel Select Both Columns And Then 1. Click On Conditional Formating

2.Select Highlight Cell Rules

And Select Duplicate Values

Utilisateur supprimé
par Utilisateur supprimé

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
par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

question is not clear, will you please give more detail

More Questions Like This