ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Summary of row (https://www.excelbanter.com/excel-discussion-misc-queries/219844-summary-row.html)

Mr-Re Man

Summary of row
 
I have a worksheet with 22000 rows on mobile telephone calls made with
various items of data, name, mobile number, number called, cost, type of
call, section etc.

I would like to just reduce the list quickly to show name, section.

I can do this by deleting rows, but it will take forever. I have tried a
pivot table, but cannot seem to remove each rows total, I have tried subform
but I cannot get it to display section, name will as it is the first column.

Any ideas?


All times are GMT +1. The time now is 06:41 PM.

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