How do I perform the following function in Excel? Currently Column C display the MAX value of D4:F4. However I need it to display an alternate value.
For instance if MAX Value is from column D, it'll display "TRAN", or if MAX value value comes from column E, It'll display "VERT" and lastly if it comes from column F, it'll display "LONG"
Thanks in advance
Aucun commentaire:
Enregistrer un commentaire