I want to build a formula in which it looks at a column in excel and if the column contains x as the value, it then finds the max of a different column. For example. = IF(F:F = "rate", Max(k:k)) but this columns up as a value error. Could someone show me how to correctly write this formula.
Thanks
Aucun commentaire:
Enregistrer un commentaire