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

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

متابعة

My question . How to match two character in excel (like order no & Products are repeated?

1 St week. A - Order No B- Product C- order Qty D- Balance Qty A -1001 B - Apple C-500 D-250 A -1001 B-Orange C-10 D500 A -1001 B Lemon C-1500 D750 A -1002 B - Apple C-1500 D-500 A -1002 B-Orange C-20 D750 A -1002 B Lemon C-3500 D102nd week. A - Order No B- Product C- order Qty D- Balance Qty A -1001 B - Apple C-500 D-350 A -1001 B-Orange C-10 D600 A -1001 B Lemon C-1500 D850 A -1002 B - Apple C-1500 D-600 A -1002 B-Orange C-20 D850 A -1002 B Lemon C-3500 D1500 how i can2nd week balance Qty pull to1st week balance Qty means order Qty Same no changes. but balance qty to be change.how to pick2nd week D(balance qty) to1st week balance Qty means2nd week balance qty showing1st week d column.

user-image
تم إضافة السؤال من قبل buhari sherif , Sales Coordinator + IT Support , KHK Scaffolding
تاريخ النشر: 2014/05/26
buhari sherif
من قبل buhari sherif , Sales Coordinator + IT Support , KHK Scaffolding

Dear Bro...thanks for your answer... sometime one product100 % delivered ..menas balance quantiy remaining0 ...100 % delivered product not showing next week outstanding ... that time how i can use above method.. above method is using when100% not delivered the product.... can you advise...

karan sandhu
من قبل karan sandhu , Senior Software Developer + Technical Support , NetSoftLab

bro if you want auto update2nd week >> Balance Qty on updating1st week >> Balance Qty

try this method :-

1. choose cell for2nd week >> Balance Qty

or

click on2nd week >> Balance Qty

2. press "=" from keyboard

3. move to1st week >> Balance Qty (alternate cell)

4. press "ENTER" from keyboard

5. again click on2nd week >> Balance Qty cell on which you pressed "="

6. move mouse at right bottom corner of that cell, it will show little + sign, click on it and drag upto last value of that column, you can increase limit anytime

7. now, try to change value in1st week >> Balance Qty

8. check2nd >> Balance Qty

9. reply me if not done properly, I will help you ()

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