• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Quick Excel Formula help

whatsupdarling

New Member
Hi,
Would you be able to give me a correct formula please.

I attached a screenshot. I need to enter the earliest date from column B into column D for Aster, Cuba, Metropolitano

For example:
Aster 08/10/2021
Cuba 26/07/2021
Metropolitano 13/07/2021

Please can you help :)
 

Attachments

  • SCREENSHOT.png
    SCREENSHOT.png
    44.4 KB · Views: 12
whatsupdarling
What kind of formula did You use?
... You could learn better, if You could show Your formula.
Syntax
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

I tested it and it works as it should work.
... and ...
eg with Pivot-table, You could get
Screenshot 2021-10-14 at 11.01.19.png
 
In the attached:
1. formula in D2:
=MINIFS($B$2:$B$24,$A$2:$A$24,$A2)
copied down to D24

2. vletm's pivot at cell G2. Right-click and choose Refresh if the source data changes

3. Power Query at cell L2. Right-click and choose Refresh if the source data changes
 

Attachments

  • Chandoo47040Book1.xlsx
    20.7 KB · Views: 1
Back
Top