Finding the minimum value in non blank cells

Chamudi Withanawasam

Also... removed the MATCH as well. It return 05/03/21 which is the start date of the Procurement task :'(

=MIN(COLLECT({TEst Project Start}, {TEst Project Parent}, 0, {TEst Project % Complete}, NOT(1)))

Chamudi Withanawasam

Ok finally figured out a way!!!! Eliminated the NOT with the value and seems like it's working

=INDEX({TEst Project Task Name}, MATCH(MIN(COLLECT({TEst Project Start}, {TEst Project Parent}, 0, {TEst Project % Complete}, 0)), {TEst Project Start}, 0))

Edit: ok no it doesn't work :3 only works for some sheets only.

I give up :( :(