Repeating numbers in same cell
1. Use Text to Columns to move the numbers to individual cells
2. Copy the row to a column using Paste/Special/Transpose
3. create Pivot Table listing the count of values by value.
--
Gary''s Student - gsnu200777
"Tabby" wrote:
I have a worksheet that has repeating numbers in one cell.
Example: 1204,1205,1206,1205,1204
Is there a formula that will total the repeating numbers? i.e. (2) 1204,
(2) 1205?
|