I’m trying to collect the latest sale date from a list of data in four columns A, B, C and D for each fabric.
Col. A contains 3 different values (either Linen, Cotton or Silk)
Col. B contains 5 different colours (either blue, green, orange, red or yellow)
Col. C contains sizes but I don’t need this at this present time so ignore
Col. D contains the date of the sale
Columns A-D are endless as sales are added so the list will run into 1000s
In columns G-J I am displaying the collected data from the long list of sales.
Col. G contains each fabric (linen, cotton, silk)
Col. H contains each colour (blue, green, orange, red, yellow)
Col. I contains total sales for each fabric/colour combination
Col. J contains latest sale date
E.G linen blue 8 latest sale, linen green 4 latest sale etc…
For Col. I the total sales are working fine. I’m using =SUMPRODUCT(A2:A5000=“linen”,B2:B5000=“blue”) at I2, =SUMPRODUCT(A2:A5000=“linen”,B2:B5000=“green”) at I3 etc, However, for Col. J I’m having no luck displaying the most recent sale.
For J2 I would like to return the most recent sale date for linen blue, J3 linen green, J4 linen orange etc…
Any advice is most appreciative as I have very limited knowledge.