filter of column problem

[CG Rosén]

Good Evening Group,

I´am stuck with a problem that seems to be above my level.
From a column with text as below I´am trying to extract the
one with the "highest" number to the most right. Would be fine if
I can get some hints.

table: looking for this extract:

01-001:1 01-001:2
01-001:2 52-001:3
52-001:1 53-001:1
52-001:2 53-002:2
52-001:3 53-003:1
53-001:1
53-002:1
53-002:2
53-003:1
etc

Brgds

CG Rosén

 

[Jim Cone]

CG Rosén,

If all of the data has the same number of characters and the same format
displayed in your example then...
1. sort the list.
2. loop thru the range looking at the first two characters in each cell.
3. whenever the two characters are not the same as the cell below,
extract the cell value to an adjoining blank column.

Regards,
Jim Cone
San Francisco, USA


"CG Rosén" <[email protected]>
wrote in message
Good Evening Group,
I´am stuck with a problem that seems to be above my level.
From a column with text as below I´am trying to extract the
one with the "highest" number to the most right. Would be fine if
I can get some hints.

table: looking for this extract:

01-001:1 01-001:2
01-001:2 52-001:3
52-001:1 53-001:1
52-001:2 53-002:2
52-001:3 53-003:1
53-001:1
53-002:1
53-002:2
53-003:1
etc

Brgds
CG Rosén