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.

41986dc6-40b8-4707-9dfe-6944602952ff

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

Can anyone please assist me with that?

Thanks in advance!
Untitled.jpg
Untitled.jpg


QrgR7y8
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top