I'm trying to compare email addresses in column A with those listed in Column C.
If any of those listed in column A don't exist in C, I'd like to delete them.
Is there an IFEXIST, True, False formula I could use to compare textstrings listed in on column that is a named range, with another?
Thanks for your suggestions...
--Bob
Hello,
you can't use a formula to delete cell contents. That would require a macro, but seeing that you are using XL 2008 for Mac, macros are not an option. You could create a formula in a separate column, say column D, then sort all values by the results in column D and delete the data in column A for these cells. A possible formula might be:
=if(isna(match(A2,C:C,0)),"delete","keep")
This is assuming that the first row has data labels and the formula starts in row 2. Copy down.
cheers,
Thank you very much for that Teylyn.
I tried the formula but all results came back "Delete".
I then substituted C:C for a named range such as "test1", thinking that it was comparing only one cell to the adjacent counterpart, but that change had no effect.
I then realized that the text in the C column had formatted domains in upper case, so I copied that column into Word, changed to all lower case, pasted back, and voila!
You are the Bomb! And...I learned more about Excel. Thank you so much for your kind help!
--Bob
FYI, match is not case sensitive, so I suspect you had other characters making it fail that you transfer to and from Word removed.
Good luck.
Interesting Rory.
There is nothing apparent, so perhaps that is one good technique to use when all else fails?
--Bob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks