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)
It doesn't seem to be what he needs