mardi 24 septembre 2019

Excel manipulating columns

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