ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Summarizing Column Data (https://www.excelbanter.com/excel-worksheet-functions/119027-summarizing-column-data.html)

ScottyC

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.




All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com