matching the column b(sku)c(count)with A
I need to match to the same row the B sku and the C qty to the same sku in row A. not all sku in b will be in A. I need this so I can get the counts in qty lined up on the same row as A for all the sku that exist in A. ATOZ is A ... prod is B and the qty is C. AtoZ # PRODUCT Qty 1002 1001 Total 14 1005 1002 Total 24 1006 1003 Total 4 10-1014-1 1005 Total 48 10-1014-2 1006 Total 33 10-1014-3 1010 Total 2 10-1014-4 10-1017-2 Total 1 10-1014-5 10-1017-3 Total 1 10-1017-1 10-1017-4 Total 1 10-1017-2 10-1056-3 Total 1 10-1017-3 10-1117-3 Total 4 10-1017-4 10-1117-5 Total 1 10-1017-5 10-1247-2 Total 2 10-1035-1 10-1247-3 Total 2 10-1035-2 10-1247-5 Total 1 10-1035-3 10-1248-2 Total 1 10-1035-4 10-1248-4 Total 1 10-1035-5 10-1248-5 Total 1 10-1051-1 10-1249-2 Total 1 10-1051-2 10-1249-4 Total 1 10-1051-3 10-1249-5 Total 1 10-1051-4 10-1250-2 Total 1 10-1051-5 10-1250-3 Total 6 -- sammc2 ------------------------------------------------------------------------ sammc2's Profile: http://www.excelforum.com/member.php...o&userid=19402 View this thread: http://www.excelforum.com/showthread...hreadid=481995 |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com