Forum Discussion
Solved
getting the row number of the first cell which satisfied the condition
How to get the row number of the first cell which satisfied the condition in excel 365?
- =MATCH("d",E1:E22,0)
5 Replies
The MATCH or XMATCH function should do that. Since you haven't provided any details, it's impossible to be more precise.
- =MATCH("d",E1:E22,0)
- I will prepare something now
