| 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 |
| 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) | |||
![larry brunster[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
