Hello there.
I have a worksheet with data I'm trying to consolidate based on potentially duplicate dates.
In Col A there is a number, Col B is a date (potentially duplicates) and then Col D I am concatenating Col A and B and adding an additional piece of data based on how many days have passed since the date in Col B.
I would like to return the data with only unique dates and the sum of the numbers is Col A that match the same date in Col B.
Gosh, I hope that makes sense. I've attached the sheet.
I've had great luck with everything on this board. I actually just got some help on a similar function and am thinking it could be modified for this. It's an IFERROR using an INDEX function. I'm just not sure.
I would appreciate any help. Thank you!
Bookmarks