I need to come up with a formula in excel that will identify the max and min software offered on a computer and input it into a new table.
So for instance, in one large table I have column names like SKU, PRICE, PRODUCT FAMILY, SOFTWARE VERSION, etc.
In another table I have a list of PRODUCT FAMILY, and I need to identify the max/min software.
Software can be sorted in excel:
But I cannot figure out how to return these as max/min values. Attempted Array Formula:
But this seems to be struggling with the non-numerical names. Does anyone have suggestions?