Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
matching column entries | Excel Worksheet Functions |