Soldato
- Joined
- 21 Jul 2004
- Posts
- 6,360
- Location
- Harrow, UK
I am trying to create a formula/script in an Excel file which is a Progress Tracker for a project. Amongst the various columns, there is a column which contains the names of certain people and this is being updated on a daily basis. A few columns to the right of that, there is a column which contains numbers.
I want to write something that will look for each occurance of a name (there are about 14 names) and then add the numbers up for that person and display them all on a different sheet.
Any ideas how to do this?
I want to write something that will look for each occurance of a name (there are about 14 names) and then add the numbers up for that person and display them all on a different sheet.
Any ideas how to do this?
