Tuesday, April 1, 2014

yogi_Find Row By Row Row Number Of Next Populated Cell In Column A

                                         Google Spreadsheet   Post  #1582
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-01-2014
post by SagRU (https://productforums.google.com/forum/#!topicsearchin/docs/after$3A2014$2F03$2F31$20AND$20-is$3Aduplicate$20AND$20-is$3Aanswered$20AND$20-is$3Aresponded$20AND$20-is$3Acanbeignored%7Csort:date%7Cspell:true/docs/8xEDwBZsP6A)
How to find a position of the first non-blank cell below?
Hello!

I have a problem with New Sheets. Let's assume I have a column of data that contains populated cells and blank cells. All I want is to be able to get a position of the first non-blank cell below. In Old Sheets I used this kind of formula:

= MATCH(TRUE;INDIRECT("B"&ROW()+1&":B")

I have no idea, how this thing with "TRUE" works in Old Sheets, but it gives me what I want (a position of the first populated cell in a given column). In New Sheets, however, such a formula returns "N/A: TRUE is not found". 

Example:

https://docs.google.com/spreadsheets/d/1kKujj3eeFm8jxW_v1ZUD_S8jpXXm0XGFhIoxvfE5ip8/edit#gid=0

------------------------------------------------------------------------------------------------

No comments:

Post a Comment