SOLVED

getting the row number of the first cell which satisfied the condition

Contributor

How to get the row number of the first cell which satisfied the condition in excel 365?

5 Replies

@ajl_ahmed 

The MATCH or XMATCH function should do that. Since you haven't provided any details, it's impossible to be more precise.

I will prepare something now

@Hans Vogelaar 

I attached a file 

Thx.

best response confirmed by ajl_ahmed (Contributor)
Solution
=MATCH("d",E1:E22,0)