Forum Discussion

Tapster's avatar
Tapster
Copper Contributor
Jun 01, 2020

IP Address Training Template

The attached is a training template that I am attempting to aid students in Networking Fundamentals. If I get it to do what I am visualizing it will most definitely help me improve my Excel skills. I...
Need Help
Tapster's avatar
Tapster
Copper Contributor
Jun 01, 2020

Tapster 

I addressed the issue I had with the original post by creating tables and using XLOOKUP. By doing so, I made some progress.

The attached is the modified version of the original file. I'm putting notes at the bottom of the sheet so I can keep up with my issues for reference.

Insight/assistance appreciated and respected.

  • Tapster's avatar
    Tapster
    Copper Contributor
    Jun 02, 2020

    Tapster 

    The attached spreadsheet is doing what I intended when I started this post with one last thing I cannot figure out. It may not be possible without writing code but I wanted to ask and see if anyone had thoughts/advice. If one looks at the file one will see "Magic Number" pointing to J5. I am trying to figure out how to get that pointer to slide down between bits 23 and 2 based on the value in B4.

    Advice/insight would be appreciated.

    TAPS

     

Resources