Get unique computer names across several sheets/columns

Hello all,

thanks in advance for any and all help.

I work in the IT field and have spreadsheets that have thousands of computer names in different columns and need to sort out the Unique names between them. how can i do this efficiently? i have already tried if statements, filter statements, count statements all with no luck for what i need.

basically i am looking to learn how to write a formula and/or macro that will allow me to compare names in sheet 1 column A, to sheet 2 Column A, and so on. what is the most efficient way to do this?

again thanks for the help.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "formula help" does not describe your problem. I have updated it for you this time because you are a new member. --6StringJazzer

I suggest you attach a sample file, or give a much more detailed description ("and so on" is not something you can write a formula or code for). Give sheet names and specific columns.

sorry i thought the "and so on" was implied sheet 3 column A and continued with multiple sheets.

Yes, that's what I assumed, but to actually write a formula, you need the sheet names. If the number of sheets is indeterminate then you would almost certainly need VBA. Also the fact that data starts in row 3 is important. So precision in the question helps us give you the best answer.

In Excel 365 I might try to do this with the VSTACK and UNIQUE functions but they're not available in 2019.

Since I am comfortable with macros I would probably use a VBA solution for this. This solution will work for any number of sheets with any names, as long as the only thing in the file is sheets with lists of computer names.

Please Login or Register  to view this content.

thank you. as we do not have O365 we do not have the "unique" function yet (we are still on office 2016 (at home i have 2019).

This VBA solution should work in any version of Excel that supports VBA.

Also, if responding directly after a post it isn't necessary to hit Reply with Quote to quote the whole post. You can just type a reply. (When a quote is required it is best to just use the relevant portion.)