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