Forum Discussion

Iron Contributor

Jul 13, 2022

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?

Formulas and Functions

mathetes
Jul 13, 2022
=MATCH("d",E1:E22,0)

MVP

Jul 13, 2022

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

ajl_ahmed
Iron Contributor
Jul 13, 2022
HansVogelaar
I attached a file
Thx.
Book2.xlsx9 KB
- mathetes
  Gold Contributor
  Jul 13, 2022
  =MATCH("d",E1:E22,0)
  - ajl_ahmed
    Iron Contributor
    Jul 13, 2022
    Many thanks...
ajl_ahmed
Iron Contributor
Jul 13, 2022
I will prepare something now

Resources