Index Match picking the smallest value

gustavocolli

New Member
Joined
Jul 18, 2018
Messages
4
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!


 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,411
Office Version
365
Platform
Windows
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
DEFGHIJ
1
2
3ProjectDateProject
4000188/30/2019ProjectMin Date
5000188/31/2019000188/30/20198/30/2019
6000188/31/2019000208/1/20198/1/2019
7000208/1/2019
8000208/2/2019
9000208/3/2019
10000208/5/2019
Sheet
 

gustavocolli

New Member
Joined
Jul 18, 2018
Messages
4
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,090,026
Messages
5,411,917
Members
403,403
Latest member
BBleaz

This Week's Hot Topics

Top