Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching & sorting data
I have a worksheet with two columns each containing thousands of UPC codes.
I'm trying to line up the data so that I can find matching UPCs between the 2 columns(I'd like my matching UPCs to appear in the same row). Here's a more visual description. What I have: How I'd like it to be sorted: A B A B 514 687 201 236 514 236 687 201 514 514 687 687 Thanks a bunch, Larry |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching & sorting data
If you just want to know if a code in A also appears in B, use
in C1 the formula =COUNTIF(A:A,B1) and copy down the column (double click the fill handle - small square in lower right corner of active cell) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "larry brunster" wrote in message ... I have a worksheet with two columns each containing thousands of UPC codes. I'm trying to line up the data so that I can find matching UPCs between the 2 columns(I'd like my matching UPCs to appear in the same row). Here's a more visual description. What I have: How I'd like it to be sorted: A B A B 514 687 201 236 514 236 687 201 514 514 687 687 Thanks a bunch, Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Sorting 2 columns according to matching cells, and fishing for duplicates | Excel Discussion (Misc queries) | |||
Sorting columns and Matching | Excel Discussion (Misc queries) | |||
Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
matching a sorting the exact value in the data list | Excel Discussion (Misc queries) |