Calculation across rows in Formula editor<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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,
