Summary of rows

M

Mr-Re Man

***IF THIS IS DUPLICATED, PLEASE EXCEPT MY APOLOGIES, I RECEIVED AN ERROR ON
CLICKING SUBMIT***

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?
 
S

Sean Timmons

To get rid of subtotals in a pivot table, right click on the row field and
click None under Subtotals...
 
G

Gary''s Student

If you post a small sample of your data, both as it appears and your desired
result, we can guide you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top