Col A is a list of dates in order with some dates missing, some dates repeated. Col C is associated numbers. I want to create a chart that would show a "date to sum" relationship of all dates, but dates should show only once. Each date, and it associated numbers, that is repeated should be combined so it represents that date in it's entirety, with it's sums, and is entered in the chart only once. How do I do this with dates that are repeated in Col A with data on corresponding multiple rows in "C"?
Bookmarks