Subscribe Bookmark RSS Feed

Calculation across rows in Formula editor

JesperJohansen

Community Trekker

Joined:

Apr 15, 2013

I need a function to return the row number of a row in which a cell in a give column meets a certain criteria or set of criteria e.g.:

  • Return the row number of the cell in Column 1 with the value "A". Assuming "A" appear only once in the data set.
  • Return the row number of the previous or next row, relative to the row in which the formula result is displayed, in which the value in Column 1 is "A". "A" may appear several times in the data set.
  • Return the row number of the cell in Column 1 with the value is closest to a given number.

I am hoping to perform the above mentioned actions directly in the formula editor,

BR
Jesper