finding 4 sets of nos. "separated by (.)" in a range

[john desouza]

Good day
This is my first interaction with the forum
My problem finding sets of IP addresses eg.
a)173.203.136.203
b) 203.117.126.40
from a two column group of info in 200000 rows sample shown below
Basically I need to find to which country code does my IP address belong

From_IP To_IP countryCode
223.223.160.0 223.223.164.255 JP
223.223.165.0 223.223.167.255 AU
223.223.168.0 223.223.175.255 KH

Thanking you in advance
b/regards

[YasserKhalil]

Can you attach your desired results?

[Glenn Kennedy]

I am not clear what is your input, what is your output? it is not clear what is in what column. Please attach a workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

[john desouza]

Out put should be in two columns
(col1)173.203.136.203 -(col2) US
reason
IP address (FROM -) 173.203.136.168 (TO-) 173.203.137.199 (REFERS TO COUNTRY-) US

[Glenn Kennedy]

how many columns is your starting material in? Please attach a sample sheet.

[Glenn Kennedy]

If the starting stuff is in a single column, this will return the FROM ip

=TRIM(MID(SUBSTITUTE(" "&$A1," ",REPT(" ",125)),125*COLUMNS($A:A),125))

and this will return the country:

=TRIM(MID(SUBSTITUTE(" "&$A1," ",REPT(" ",125)),125*COLUMNS($A:C),125))

[john desouza]

I regret I am unable to attach the file, it just wont happen
my data is in 3 columns
(col1) From_IP
(col2)To_IP
(col3)countryCode
The sample is in my first post

[john desouza]

Hi
the formula should look for the value to be
equal to or greater than value in column 1 and less than or equal to value in column2
where this condition matches the value of column 3 should be displayed.

Please note the values in column1 and column2 are IP addresses which means numbers separated by "."
eg.
1.0.127.255
38.104.245.15
204.239.17.255
212.197.203.0

I am still trying to attach a snap of the excel file.
b/regards