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!
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!

