Turning in my spreadsheet wizard badge.
August 2, 2011 10:33 AM Subscribe
Spreadsheet question: I want a column containing all the names in THAT column EXCEPT all the names in THOSE columns.
posted by Salvor Hardin to computers & internet (6 answers total) 5 users marked this as a favorite
Ok, here's the deal.
I have a spreadsheet. It's a google docs spreadsheet, but I'd be open to using another kind of spreadsheet if what I want just isn't possible on a google docs spreadsheet.
Cells A2:A93 contain a bunch of unique names.
Cells C2:N15 contain a bunch of names as well as blank cells. Not all names in A2:A93 are in C2:N15, but all names in C2:N15 are in A2:A93.
I would like a formula that magically makes column B contain all the names that ARE in A2:A93 but NOT in C2:N15.
Is this possible? How do I do it? Thank you!