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

Return list of row numbers of cells that contain a numeric value

I’d like to have a formula that will extract the row number of each numeric value. Also, I do not want to end up with empty cells (or values like "not numeric"). This needs to be a formula, for repeatability. For example, source column looks like this:

+--------+
| Foobar |
+--------+
| Foobar |
+--------+
| 123    |
+--------+
| 123    |
+--------+
| Foobar |
+--------+
| 123    |
+--------+

I want to end up with:

+---+
| 3 |
+---+
| 4 |
+---+
| 6 |
+---+

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 :

=FILTER(ROW(A1:A6),ISNUMBER(A1:A6)) if it starts in the first row

Else =TOCOL(SEQUENCE(ROWS(C2:C9))/C2:C9^0,2)

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