View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Have the need to sort text code-values within same Excel cell

Say each of the cells in column A contains a list of 5 codes separated by
commas.

First copy column A into columns B, C, D, and E.

Next set and AutoFilter for each column:
column A "contains" X
column B "contains" A
column C "contains" B2
column D "contains" T83
column E "contains" M19

The autofilter will display all the rows that have the same contents,
regardless of the order the codes appear.
--
Gary''s Student - gsnu200909


"A.X M.D" wrote:

Got column with thousands of cells containg different codes, e.g., cell P357
-- {X, A, B2, T83, M19}; cell P425 -- {T83, A, X, M19, B2}, etc ... Need
a way to sort these individual cells in a similar order so I can aggregate
the number of cells containing the same set of codes/values ...

I am somehow familiar with the basic Excel functionality but above situation
is really challenging me !

Thanks in advance ..