Home |
Search |
Today's Posts |
#1
|
|||
|
|||
identify duplicates
I'm trying to match two rows of data and identify duplicates
|
#2
|
|||
|
|||
An inelegant solution would be to transpose the rows into columns and then
use the VLOOKUP function. Try transpose the first row and put it in column A, in column B put a bunch of 1's. Transpose row 2 and put it in column D. In column E put a bunch of 1's. Then use VLOOKUP, the formula (in F1) would look something like: =VLOOKUP(D1,A:B,2,FALSE) where you see a one, it's a duplicate, where you see an error, it's not. Drag this all the way down. Then do the same thing but with formula: =VLOOKUP(A1,D:E,2,FALSE) Hope this helps... "5thsun7thchild" wrote: I'm trying to match two rows of data and identify duplicates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicates then calculate..??? | Excel Worksheet Functions | |||
How do I identify dulicate rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
How to indentify duplicates in a "Self Populating" field? | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions | |||
Finding and Deleting duplicates in a column | Excel Worksheet Functions |