In Excel or Google Sheets, how to return the highest value of a string with a number in another cell?
I have a column which contains different Letters each with a corresponding number. I.E. (F1, F2, F3) denotes three products from the ‘F’ category, and (G1, G2, G3) denotes products from the “G” category. These “Product ID’s are all in the same column.
In Excel or Google Sheets, how to return the highest value of a string with a number in another cell?
I have a column which contains different Letters each with a corresponding number. I.E. (F1, F2, F3) denotes three products from the ‘F’ category, and (G1, G2, G3) denotes products from the “G” category. These “Product ID’s are all in the same column.