vendredi 11 septembre 2015

Return the row of first non-blank cell in Excel

Let's say I have the array A1:A5 in excel:

    A  
1    
2  
3  'test'  
4  
5  'test2'

How can I return "3"? I'm looking for something in Excel formulas. The blanks are genuine blanks.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire