Forum Discussion
Consolidating Data
I am not a pro at Excel but I did try researching this for some time. This is an example. In column E I have 12,000 items that are duplicates but I want to add them up to show totals of how many time...
Here is a simplified suggested solution with the formula =SUBRESULT.
You must first insert the data into a spreadsheet.
Sample file is included.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
I don't want to add up all referring providers at once but with 12,000 rows of information in colum "E" Referring Providers, I want it to add up like this. Can you help me please?
As I already informed you in my suggested solution, you have to put your data in a table, then you can simply filter by name, as in the example file, and the number of visits by the selected person will appear immediately.
- https://answers.microsoft.com/en-us/msoffice/forum/all/excel-question/86df10eb-eeca-418e-8abd-5a833f3f2f8e
count(*) group by Referring Provider
like above situation?- Yes, I am probably tired and struggling. I will try again tomorrow. Thank you.
- It doesn't seem to be what he needs
