Summarizing Column Data

S

ScottyC

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