| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare last octet of IP address
Seems simple
however I've tried using some kind of combination of substitue / find / mid and right functions however I can't seem to get it to work.. please don't tell me not to use spreadsheets for ip address management / natting (Thanks) 10.10.15.35 should match 192.168.95.35 but not match 192.158.96.135 can someone help here? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| what is difference between absolute address and relative address? | Excel Discussion (Misc queries) | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| How Do I sort an IP address by the 3rd Octet? | Excel Worksheet Functions | |||
![Ant[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
