Forum Discussion
Assigning Source IP to Client excel function
Here is an upside-down solution from (5/15/05) Rob Bovey, Created.
I found it on the internet a long time ago. Maybe it will help you.
I would be happy to know if I could help.
I wish you continued success with your Computer
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
- no sure how this will help. All I see is a get IP address button.
- Does "Vlookup" help you?
Here is a suggested solution with a data check.
If an IP is registered and already exists, a message comes up.
Exactly the same with the users, if the user is already there, a message comes up.
But that only helps if all IPs and users are entered individually from the start.
I can't quite understand your plans.
Would you like to assign the name of the PC from the specified IP? ...That's how I understood it.
How does that work? can all IPs be pinned on?
However, I recommend that you send a file (without sensitive data) and explain your plans on it.
This way, even cumbersome people like me :)) can understand your plan.
Thank you for your patience and understanding
Nikolino
NikolinoDE The Ip address and devices are not individually entered from the start in a table/chart format. Is there a way around this? If you see the attached file, you'll find there are 20,000 lines of data, and let's say for example 10% of the lines are individual IP addresses (repeated), so around 2000 unique addresses. Creating a table with 2000 IP addresses and device names will be time-consuming.
I am going to try to convert the data into a table format, sort the ip address and then assign a device to the ip addresses. Let me know what you think?
