lundi 13 juillet 2020

Excel Formula =If(min),true, false

What formula do I need to label data based on two criteria, one of which is the minimum?

I am trying to label each row of data with a "Y" or "N". In the example below, I am trying to find the object (row) where the minimum price (criteria 1) for each shelf (criteria 2) can be found.

Example Data

thank you in advance!

Aucun commentaire:

Enregistrer un commentaire