sandeep28585
New Member
- Joined
- Mar 25, 2020
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi ,
I was trying to run a formula where if any bigger subnet (/20,/19) added to column and it will fill the /24 in another column.
I was somewhat succeeded for the subnet which i am using but if the subnet changes then the formua did not worked for me.
As an example :
I tried for 10.110.120.0 and it worked but if the any changes on the first three octets it did not worked.I am not sure whether this can be achieved with formulas or any scripting is required.
I was trying to run a formula where if any bigger subnet (/20,/19) added to column and it will fill the /24 in another column.
I was somewhat succeeded for the subnet which i am using but if the subnet changes then the formua did not worked for me.
As an example :
I tried for 10.110.120.0 and it worked but if the any changes on the first three octets it did not worked.I am not sure whether this can be achieved with formulas or any scripting is required.