Lewenhaupt
New Member
- Joined
- May 31, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
Hey everyone, I haven't found the answer so I am asking here by myself.
I have a table full of IP Addresses.
-In column A and B I have addresses to check if they are repeating.
-In C column I have check if IP in A is in B, and in column D I have a check if IP in B is in A.
I'm using vlookup for it. Now in C and D I have either IP Address or #N/A. How can I count how many IP addresses are in the column without counting the N/A cells?
Thank you all for help
I have a table full of IP Addresses.
-In column A and B I have addresses to check if they are repeating.
-In C column I have check if IP in A is in B, and in column D I have a check if IP in B is in A.
I'm using vlookup for it. Now in C and D I have either IP Address or #N/A. How can I count how many IP addresses are in the column without counting the N/A cells?
Thank you all for help