Ask Your Question

How to collect the latest sale date.

asked 2017-01-19 21:14:15 +0200

totally stumped gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-19 21:55:51 +0200

karolus gravatar image

Hallo Use →insert→Pivottable

Pivottable aka Datapilot

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-19 21:14:15 +0200

Seen: 35 times

Last updated: Jan 19 '17