Hello,

I'm quite new to excel and I've come up against a challenge.
I'm working on a project where I have an Excel spreadsheet with 12 pages of both arranged and un-arranged IP addresses in different columns and around other data.

Some are just subnet mask ranges i.e from a subnet mask start of 10.3.65.1 in column A to a subnet mask end of 10.3.65.255 in column F; So the in between ranges are not individually written out.
Some just seem to be random lists of IP addresses in no particular order.

What I've been asked to do, is take one list of IP addresses and compare them against all of the sheets to find any duplicates.
The ones that are duplicated would need to be displayed in a separate table in a separate sheet with how many times they are duplicated within the spreadsheet across all sheets and where it is that they are duplicated.

Is this possible to do by writing a formula?
I could possibly write a Macro if I knew how to but I can't import any macros into the spreadsheet due to security restrictions although I could potentially copy and paste code.

If any one has any questions or ideas please let me know. Apologies if I've not explained myself very well.