Index Match picking the smallest value

[gustavocolli]

Hey all,

I am cracking my head without finding a logical solution for this problem.

This is a small picture of my database (on the left) and I created a pivot table (on the right) to summarize this information. I would like excel to get the lowest number from the column G (date) and insert it on the column A (Date created) from the pivot table, using the columns Project as reference.

So, for example, for the project 0000016, excel should give 30/08/2019 as well as for the project 00000020, excel should give 01/08/2019.

https://imggmi.com/full/2019/9/20/036d002cfdd6372688085dada9a6bd2b-full.jpg.html

Can anyone please assist me with that?

Thanks in advance!

 

[AhoyNC]

With the Pivot Table you could drag dates down to the VALUE field.
Then click on Drop Down Arrow
-Value field setting
-Min

With a formula you could use the array formula in I5 in the example below that must be entered with CTRL-SHIFT-ENTER. Then drag formula down.
If you have a later ver. of Excel with the MINIFS function then the formula in cell J5.

Excel Workbook
	D	E	F	G	H	I	J
1
2
3	Project	Date				Project
4	00018	8/30/2019			Project	Min Date
5	00018	8/31/2019			00018	8/30/2019	8/30/2019
6	00018	8/31/2019			00020	8/1/2019	8/1/2019
7	00020	8/1/2019
8	00020	8/2/2019
9	00020	8/3/2019
10	00020	8/5/2019
Sheet

 

[gustavocolli]

Man you're amazing. Thanks a lot for your help!

I don't know why but I couldn't get the smallest value with the pivot table, but using (the second) spreadsheet formula worked perfectly. Cheers!