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:
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
------------------------------------------------------------------------------------------------
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/
------------------------------------------------------------------------------------------------
No comments:
Post a Comment