Hi Mike,
I hope you all are doing well, I required your help to resolve my issue in
excel.
On single worksheet i have two different sheet name as 1.IP Range 2. Result.
Question:
EG:IP Range
Start IP End IP
Area
192.168.1.4 195.182.254.254 AG
10.15.33.10 10.18.56.254
EMEA
10.128.33.5 10.132.40.60 AP
Here it will Continued as well.
On Result sheet i required result like:
IP Area
192.170.30.30 AG
194.168.10.20 AG
10.131.37.20 EMEA
10.170.255.255 NA
10.129.36.8 AP
I required result on area column. Here we have more than 50000 IP's but very
difficult to find the area.
Could any one please help me on this issue. How i can resolve the issue
Thanks in advance
Deen
Deen said:
Hi Mike
Thanks for your reply, Is working great
Mike H said:
Deen
Use the formula
=B2-A2
Format the formula cell with a Custom format of [h]:mm
Drag down
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
Deen said:
Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM 15:00
See herewith i required the result like need to calculate time duration B-A,
Any one can help me on this.
Thanks in advance
Ahamed
