Finding Min-Max

Question

Issue Not able to get Min-Max of parts using formulas, shows wrong value

What I did

Here is my formula

=MAX(VLOOKUP(A2,TAT!A:C,3,FALSE))& "/" &MIN(VLOOKUP(A2,TAT!A:C,3,FALSE))

Here is sheet 1

Here is sheet 2

Results that I want? Basically, I just want the Min-Max from TAT sheet to be shown in BER Summary Sheet in the Min-Max TAT column. What I want it to show

Is something wrong with the formula or am I not using the right approach to the formula at all?

VLOOKUP returns the first match only and not all of them so the min and max will be the same number always. What version do you have? — Scott Craner
– Scott Craner, Commented Jul 7, 2022 at 21:19

Scott Craner · Accepted Answer · 2022-07-07 21:50:14Z

1

In Office 365:

=MAXIFS(TAT!C:C,TAT!A:A,A2)& "/" &MINIFS(TAT!C:C,TAT!A:A,A2)

answered Jul 7, 2022 at 21:50

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Attitude Black Over a year ago

DUDE! It worked. Thanks a lot. But could you tell why did we use MAXIFS and not just MAX? Thanks

Scott Craner Over a year ago

Because max will return the max of everything, while Maxifs will filter the data based on the criteria and only return the max of the filtered data. If this worked, please consider marking it as correct by clicking the check box by the answer.

Collectives™ on Stack Overflow

Finding Min-Max

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related