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...
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.