hi everyone,
I have a worksheet ("Dashboard")with names in column H (range is h3 down ) and their $ values in Column F (F3 down).
I need to somehow find the total value for each of the names (most of the names appear more than once...) and put them into another worksheet called 'Totals' starting at Column C, row 3.
So in effect if the name Sarah appears 10 times in column H there would be values for each entry in the adjacent column F.
So the results on the "Totals" worksheet would have something like:
C B
SARAH 10,000 (10,000 being the cumulative total)
CORN 20,000
I'm not sure if a macro or formula is best for this..
Thanks in advance,
Bookmarks