Query2. Find out Oldest Date based on a Condition

We have to find out oldest date with least time for a particular ID.

Scenario: We have a list which have some User IDs and their Sales time with dates. We have to find out oldest time for each User IDs which are highlighted.

See below image: I Have typed this formula:

"=MIN(IF($A$2:$A$13=A18,$D$2:$D$13))"

Press Ctrl+Shift+Enter, as this is an array function

Let's learn how the formula works:

The If Function returns the range which refers to particular user ID which is in Cell A18 (1). However, Min function tells us the Minimum value from the range which If function returns.

-----------------------------------------------------------------------------------------------------------------------------------------------

Download the file : Find Oldest Date.xlsx

Thanks for learning, please give your valuable feedback/comment if it's helpful.