Summarizing report
Please see enclosed example. I am looking for a macro or other method to summarize the lines in the INPUT tab into the table on the OUTPUT tab. The original spreadsheet as 48,000 lines so no manual cut and pastes or copies. Any ideas welcome.
UPDATE: I solved the issue myself with one formula, which I was able to paste down the sheet once. Then I ran a pivot report and I was good to go. See enclosed spreadsheet col. J.
Attachment | Size |
---|---|
mockup.xlsx | 14.2 KB |
Recent comments
6 years 4 weeks ago
6 years 42 weeks ago
7 years 2 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 11 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 20 weeks ago
7 years 20 weeks ago