I am using Excel 2013 ... vba
I have uploaded a sheet. It has two columns with headers "Name" and "Hours".
There are two named ranges...
The range "Name" has duplicate entries. Each entry has an entry in the "hours" column.
I would like a lightning fast analysis. I need the total hours for each "Name" entry. Ideally, a 2 dimensional array would be great.
I would prefer it in VBA, but open to suggestions.
At first, this problem seemed easy. It's not so easy!!