I have a table where I need to add two cells (D4 and D5) when dates are identical (in this case 12-6-2013 to 1-8-2014).
Capture.PNG
I would like to create a new table that looks like the second image (not necessarily in the same cells).
Capture2.PNG
I had thought that VLOOKUP and an IF statement could help, but I'm not sure how to work it out. Hoped someone could point me in the right direction.
Thanks.
Bookmarks