Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two columns
I have two colums: A and B, both containing text. In A I have 15000 rows, in
B I have 1000 rows. I need to identify the rows where values in A also are in B. How can I do this? |
#2
|
|||
|
|||
One way, in D1:
=NOT(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,FALSE))) Fill down to D15000 HTH. Best wishes Harald "BPR" skrev i melding ... I have two colums: A and B, both containing text. In A I have 15000 rows, in B I have 1000 rows. I need to identify the rows where values in A also are in B. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
can't insert columns between columns | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |