Hi, Help needed,
I have a document with 2500 rows of data. It is basically Name, amount sold, % etc.
I have data sorted these by name and I have many duplicates as my team work in different locations. I am hoping there is a way to total the amount sold for each duplicate name, without having to add a row and auto sum each time. Then I can simply data sort by amount sold to see my best performers. Any tips help and advice greatly appreciated
Cheers Ped
Auto Add repeated items
-
-
-
Re: Auto Add repeated items
Hi Peds,
Nice to meet you in Ozgrid.
Subtotal followed by sort will work for you.
Regards, junho -
Re: Auto Add repeated items
Thanks Junho, looks a great site for what i need , Also I will attach an Example of what I am looking at could you point out where and how I would add the subtotals. I am trying to avoid adding rows then doing an auto sum as I have 2500 rows to go through and most have multiple entries
-
Re: Auto Add repeated items
Peds,
Do not quote entire posts in your replies. I've delete the quote from your previous post.
Please follow these guidelines when quoting:1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
2. Quote ONLY the specific part of the post that is relevant -- not the entire post.This will keep thread clutter to a minimum and make the discussion easier to follow.
-
Re: Auto Add repeated items
Why not use a pivot table
-
Re: Auto Add repeated items
Thanks , Exactly what I am after , one more thing when I try it I have lots of drop down lists not a data list and then all the relevenat headings aloong the top. I ahve also notoced that mine appear as "count" not "sum". Any ideas ?
-
Re: Auto Add repeated items
You can change the 'Count' property by going to the field settings.
QuoteI have lots of drop down lists not a data list
not sure what you are pointing here.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!