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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,402
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!
 

Forum statistics

Threads
1,089,236
Messages
5,407,061
Members
403,120
Latest member
trpkumar

This Week's Hot Topics

Top