Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Hostname from IP address

Hi,
I am hoping someone can help me please..
I have a spreadsheet that is linked to a survey being hosted on our website.
The survey is about internet safety and one of the questions it ask is what
is your ISP? However it seems that not everyone here in Bahrain knows this
and their entries are not valid. However we trap the IP addess in the survey
results and these are pulled into the spreadsheet along with all the survey
answers.

column a column b column c column d
IP Address Sex Age Nationality etc..
193.188.105.25 M 32 Bahraini etc..
84.235.101.66 M 33 Lebanese
83.136.59.145 F 28 Bahraini

I want to find a way of converting the IP Address into an ISP name or at
least the hostname. Can anyone help?
I also want to calculate the average ages of males or females by
nationality, i was using =Averageifs(column B,column d,"Bahraini", Column b,
"F") but this gives me an error.
I am sorry if this is the wrong forum but I am really stuck!

Kind regards
Nick


--
Internet Safety Advisor
Telecommunications Regulatory Authority
P.O. Box 10353 Kingdom of Bahrain
Tel +973 1752 0000
Fax + 973 1753 2125


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default Hostname from IP address

Hi Nick

To convert the IP Addresses into ISP Names (or Hostnames) you'd have to have
a database to refer to. These can be purchased online from sites such as
http://www.ip2geo.net/

You were close to the correct formula, but here it is:

=averageifs(c:c,b:b,"F",d:d,"Bahrini")



"NickT" wrote in message
...
Hi,
I am hoping someone can help me please..
I have a spreadsheet that is linked to a survey being hosted on our
website.
The survey is about internet safety and one of the questions it ask is
what
is your ISP? However it seems that not everyone here in Bahrain knows this
and their entries are not valid. However we trap the IP addess in the
survey
results and these are pulled into the spreadsheet along with all the
survey
answers.

column a column b column c column d
IP Address Sex Age Nationality etc..
193.188.105.25 M 32 Bahraini etc..
84.235.101.66 M 33 Lebanese
83.136.59.145 F 28 Bahraini

I want to find a way of converting the IP Address into an ISP name or at
least the hostname. Can anyone help?
I also want to calculate the average ages of males or females by
nationality, i was using =Averageifs(column B,column d,"Bahraini", Column
b,
"F") but this gives me an error.
I am sorry if this is the wrong forum but I am really stuck!

Kind regards
Nick


--
Internet Safety Advisor
Telecommunications Regulatory Authority
P.O. Box 10353 Kingdom of Bahrain
Tel +973 1752 0000
Fax + 973 1753 2125



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I avoid excel change absolute address to relative address Miguel Excel Discussion (Misc queries) 3 May 10th 07 11:18 PM
Converting list of IP Addresses to list of Hostname M. Eteum Excel Worksheet Functions 0 March 23rd 06 07:16 PM
long address list, name-address-city, listed vertically, how do y. kb Excel Discussion (Misc queries) 2 March 4th 05 01:48 AM
How do I import Office address book to Outlook Express address bo. snnorp Excel Discussion (Misc queries) 2 February 22nd 05 12:47 PM
Using =address to provide address location for =average ahills Excel Worksheet Functions 2 November 30th 04 04:10 AM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"