Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

How do I pass the value of Row() into the ArrayFormula function in Google Sheets?

I want to always have the current Row number in this formula:

=ArrayFormula(IFNA(match(2,1/(A5:5<>""))))

The ROW() function works for getting the current row number. How can I implement it into this ArrayFormula() like this? I imagine it working like this but it doesn’t:

=ArrayFormula(IFNA(match(2,1/(A&ROW():ROW()<>""))))

How do I pass the value of Row() into the ArrayFormula() function?

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

this is not an arrayformula issue…

constructed range always needs to be INDIRECTed:

=ARRAYFORMULA(IFNA(MATCH(2, 1/(INDIRECT("A"&ROW()&":"&ROW())<>""))))
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading