modus Max and median formulas.

[Belleke]

See example

 

[Peter Bartholomew]

A key step can be to use IF to filter the data
= IF( Data[Name]=@name, Data[Numbers] )
Alternatively this can be done using the FILTER function
= FILTER( Data[Numbers], Data[Name]=@name)

From there, one simply nest the array within the chosen function e.g.
= MEDIAN( IF( Data[Name]=@name, Data[Numbers] ) )

In the case of MAX, MAXIFS offers a simpler solution and returns the results for each name as a single dynamic array
= MAXIFS( Data[Numbers], Data[Name], name )

 

[Belleke]

Can you show it in my example please.

 

[Peter Bartholomew]

No guaranties that the Office 365 dynamic arrays come over OK!

 

[Belleke]

I am working with office 2016

 

[Peter Bartholomew]

OK. I had trained myself to enter all data using CSE (Excel 2010) but now it is entirely dynamic array (Office 365 insider channel)!

For one day only, Tables! I have also deleted the FILTER formulas.

 

[Belleke]

Thank you, now It is to late for me.
I come back to it.