If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selecting matching items in a column | Panajohn | General Discussion | 2 | August 15th, 2005 09:52 PM |
Running total w/2 columns - Excel | RagDyeR | Worksheet Functions | 2 | August 10th, 2005 04:28 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
How can I sort an entire spreadsheet from a list | prod sorter | Worksheet Functions | 4 | November 17th, 2004 03:43 AM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |