Hello,
I am trying to put together a couple of data sets to get a number.
I have a Table full of mac addresses
Table1 Column header is "User MAC"
Type of data in column is 34-C0-59-7D-DF-E7
I have a second sheet with just basic data like this
Samsung Devices
34-C0-59
34-C0-58
34-C0-60
I want to do a countif that will count the samsung devices in the Table1 "User MAC" column based on whether or not the MAC address begins with ANY of the Samsung vendor ID's listed in the second sheet.
Any help is appreciated. Thank you
Dallas
Bookmarks