| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing, Sorting,countig Mac address and vendor names
I tried the Preview feature and lost the attachment, here it is ...
here is the Macro I wrote to extract the 1st-6 digits of the MA address for caomparision to the vendor list ----------------- Option Explicit Private Sub Analyse_Click() Dim i As Integer For i = 1 To 5000 Sheet1.Cells(i, "B") = Left(Sheet1.Cells(i, "A"), 6) Next i End Sub ------------------------------ Its not letting me uploadt a 200kb file...well the column A had all the mac address...for testing purposes..here are few 0000c5099510 0000c509a113 0000c509b995 0000c509b9f8 0000d12094a1 0001034db20b 0001034db4b8 000103794995 000124701cd3 00012480477f 0001248060ac 000124806101 00012480731e 000124809752 00012480b8bb 00012480d38e 00012480f5d0 000124811b1d 000124812453 00012481672e 000124819605 00012481b2a6 00012481dc07 ------------------------ Thank -- 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 | |||
![amitubale[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
