I have a number of cells with week numbers listed in a column, eg:
A1 = Wk01A2 = Wk02A3 = Wk09A4 = Wk32A5 = Wk24
I would like to extract MIN and MAX week.
Could you suggest a formula?:
A10 = MAX_Formula (A1:A5) = Wk32
Wk32
Aucun commentaire:
Enregistrer un commentaire