I have products with dimensions in fields: DimL, DimW, DimH. I need to find the highest value, middle value and lowest value per each row, not column. Max and Min functions seem to work with columns and wouldn't give me the middle value. Nested IIF and Switch functions seem overkill. Is there a simpler to find DimHighest, DimMiddle, DimLowest?
thanks