identifying file names appearing in 2 different columns / formulas...?

[ribjig]

can the following be accomplished in single sheet Excel doc?
(inserting additional columns with formulas AOK)

column A: ~140K rows with ~140K different file names

column ?B?: ~48K rows with ~48K different file names,B is subset of A but B & A file names order differ

column ?C?: ~140K rows, cells stating either "exclusive" if A file not in B, or "non-exclusive" if A file also in B

Thanks in advance! (hope this description explains...)

[Pete_UK]

Try this formula in C2 (assumes you are using row 1 for headers):

=IF(COUNTIF(B:B,A2),"non-exclusive","exclusive")

Copy down as far as required.

Hope this helps.

Pete

[ribjig]

Thanks!
Will be trying asap.
regards

update: seems to work -- worth its weight in gold !!

[Pete_UK]

Glad to help, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete