Dear All
I am using Excel for Mac 2008 and I can't activate the VBE function. I have a very long code made of numbers and text as the example below:
"661270027-2","1465607302-2","600752322-2","2704608-2","560073572-2","1249297624-2","556533864-2","561251776-2","572372400-2","548584429-3","548584429-0","512879918-2","511218371-2","841230300-2","596398500-2","666150726-2"
The codes are all separated by -#"," and when I extract them and paste them on Excel they all go into the same cell A1 example below:
<tbody>
</tbody>
1) I would like to separate the long code into different rows and get rid off the -#"," at the same time so i can keep just the numeric codes I am interested about. example below:
<tbody>
</tbody>
2) I would like Excel to find any duplicates among the clean codes (if any) and alert me somehow (highlight is ok)
3) I would like Excel to "tell me" which codes duplicate the most (if any) perhaps organising them by numerical order (starting with the one who duplicates more often..)
I know I am asking a lot but all your help is very very much appreciated.
Cheers
I am using Excel for Mac 2008 and I can't activate the VBE function. I have a very long code made of numbers and text as the example below:
"661270027-2","1465607302-2","600752322-2","2704608-2","560073572-2","1249297624-2","556533864-2","561251776-2","572372400-2","548584429-3","548584429-0","512879918-2","511218371-2","841230300-2","596398500-2","666150726-2"
The codes are all separated by -#"," and when I extract them and paste them on Excel they all go into the same cell A1 example below:
A1 661270027-2,"1465607302- 2","6007523222","27046082","560073572-2"," | |||||
B1 | |||||
C1 |
<tbody>
</tbody>
1) I would like to separate the long code into different rows and get rid off the -#"," at the same time so i can keep just the numeric codes I am interested about. example below:
B1 661270027 |
C1 1465607302 |
D1 600752322 |
E1 2704608 |
F1 560073572 |
<tbody>
</tbody>
2) I would like Excel to find any duplicates among the clean codes (if any) and alert me somehow (highlight is ok)
3) I would like Excel to "tell me" which codes duplicate the most (if any) perhaps organising them by numerical order (starting with the one who duplicates more often..)
I know I am asking a lot but all your help is very very much appreciated.
Cheers