• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to confirm MAC address in a Range or not ?

I

IceFrogBG

Member
Hello everyone,
I have a List MAC address for product (start/end address ,totalnumber),
And I want to confirm a small range is in origin range or not .
Ex : Origin Range : 0080F0BF9522-0080F0BF9585
Range need to check : 0080F0BF9550-0080F0BF9560
Can you give me some idea or method to check ?
Thank all so much.
 
assuming the range is between 4 last digits, there are ways with PowerQuery to do it. I have not checked if I can improve, simplify, shorten,... the solution, but perhaps this basic one may work.
 

Attachments

  • matching macaddressesrange.xlsx
    29.6 KB · Views: 4
You must log in or register to reply here.
Back
Top