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 3 weeks ago
6 years 41 weeks ago
7 years 1 week ago
7 years 3 weeks ago
7 years 5 weeks ago
7 years 10 weeks ago
7 years 18 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago