ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل buhari sherif , Sales Coordinator + IT Support , KHK Scaffolding
تاريخ النشر: 2014/05/24
zohaib khan
من قبل zohaib khan

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
من قبل Atif Tanveer , Decision Support Specialist , Hamilton Health Science

question is not clear, will you please give more detail

المزيد من الأسئلة المماثلة