mercredi 1 avril 2015

Excel Funcion Count and Find values

I use this function to count how many times these values appear:



=COUNTIFS(I:I;">100";I:I;"<300";A:A;"=1")



result: 3



How can i find the rows from this result?


Aucun commentaire:

Enregistrer un commentaire