View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CG Rosén CG Rosén is offline
external usenet poster
 
Posts: 74
Default filter of column problem


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