jackiehawker
Thread Starter
- Joined
- Sep 29, 2008
- Messages
- 2
Hi there,
I can do simple sums/formulas in Excel but have come across something i need help with.
i have managed to download a really useful report for us, but have a lot of duplicates, and want to know how to slim down this report taking out the duplicates and adding them up...i.e.
name 1
name 2
name 3
name 1
name 1
name 4
name 2
I want to be able to filter this information so it looks something like this:
name 1 = 3
name 2 = 2
name 3 = 1
name 4 = 1
(the report has over 2000 entries so dont want to do it manually)
Any help will be appreciated a lot.
Thanks
I can do simple sums/formulas in Excel but have come across something i need help with.
i have managed to download a really useful report for us, but have a lot of duplicates, and want to know how to slim down this report taking out the duplicates and adding them up...i.e.
name 1
name 2
name 3
name 1
name 1
name 4
name 2
I want to be able to filter this information so it looks something like this:
name 1 = 3
name 2 = 2
name 3 = 1
name 4 = 1
(the report has over 2000 entries so dont want to do it manually)
Any help will be appreciated a lot.
Thanks