Min & Max per (XLarge, Large, Med & Smal)

[Charlene Durand]

I have a list of clothing sizes that i now need to work out the max size for large, Medium and small and xsmall there are different numbers from 23 - 44 and i don't know the actual measurement of the large (xLarge can be included in this), Medium, Small need to work it out from these numbers i have Received

 

[saboh12617]

Hello Charlene,
I do not think your problem is related to Excel directly. Maybe you could look there to find size equivalences for France https://parisjetaime.com/article/poids-et-mesures-tailles-et-pointures-france-a535
Otherwise please reformulate your problem as it is not very clear.

 

[Kaper]

As you are using current version of excel, then how about using dedicated functions: MAXIFS and MINIFS (If I remember well, they were introduced with Excel 2019)

 

[Charlene Durand]

I am using the current Version. sorry i did not make this clear enough. but i have now manually done it.