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 ..
|