View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ScottyC ScottyC is offline
external usenet poster
 
Posts: 3
Default Summarizing Column Data

Hi All;

I need guidance on creating a formula that picks differences out of an
entire column of data and shows them in a single cell.

Example

1/1
1/1
1/1
1/1
1/1
1/2
1/2
1/3

I am trying to get Excel to summarize in one cell the different data sets in
a format similar to: 1/1;1/2;1/3. If all the data in the column is the same
(ex, 1/1), then it would just need to output: 1/1.