| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing, Sorting,countig Mac address and vendor names
Hello,
I have a list of @6000 mac address in excel sheet. I am trying to writ a macro to compare the mac addr to iee URL=http://standards.ieee.org/regauth/oui/oui.txt]oui.txt[/url] I am have tried to go thur tutorial ans was able to wire a macro t extract the 1st 6 digits from the mac-address, manually sorted it an now I would like to find the occurance of unique 1st-6digit of the address and then compare it to the oui.txt list to get th vendor names. Thanks -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
| countig of nonblank cells with speciffic condition | Excel Worksheet Functions | |||
| Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| Creating a Vendor ID from Vendor Name... | Excel Worksheet Functions | |||
Threaded Mode
