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

[ajl_ahmed]

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

[#2]

@ajl_ahmed 

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

[#3]

I will prepare something now

[#4]

@Hans Vogelaar 

I attached a file 

Thx.

[#5 · Accepted solution]

=MATCH("d",E1:E22,0)

[#6]

Many thanks...