I really dont know how to do this but I'm pretty sure it'll be easy for most here. I have a worksheet called 'Services', there is data from cell B11 down. I was wondering if there is a way to, firstly count how many unique distinct values there are and then the values that are the same in the B column add the corresponding values together in the E column and put those added values in an array. Thanks in advance!
Bookmarks