Google Spreadsheet Post #1450
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-26, 2013
question by Jaxiu (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/wibFsP5pUw0)
Returning last populated cell and rows adjacent to it, and more...
I have a sheet called "raw_data"
- it has 4 columns with data in them
- only column A always has data in it
I've been using this code to return the last populated cell from row A:
=INDEX(FILTER('raw_data'!A:A; NOT(ISBLANK('raw_data'!A:A))); ROWS(FILTER('raw_data'!A:A; NOT(ISBLANK('raw_data'!A:A)))) )
it works like a charm, but I also need data from other columns from the same row,
and I can't use the same code by simply changing the "A:A" because cells in row B, C and D can be null
That's my first problem, the second one is:
I need to return a populated cell before the last one BUT it has to be different than the one that I get from the code above, and also the rows adjacent to it.
I'm sorry if this has been posted before, I tried figuring it out on my own, but I just hit a wall.
Thanks in advance for any help.
---
There you go:
http://docs.google.com/ spreadsheet/ccc?key=0AoOeJJd- r16wdDkyY055TG5vOXNMZmN4SmRKQU h5R2c&usp=sharing
-----------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-26, 2013
question by Jaxiu (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/wibFsP5pUw0)
Returning last populated cell and rows adjacent to it, and more...
I have a sheet called "raw_data"
- it has 4 columns with data in them
- only column A always has data in it
I've been using this code to return the last populated cell from row A:
=INDEX(FILTER('raw_data'!A:A;
it works like a charm, but I also need data from other columns from the same row,
and I can't use the same code by simply changing the "A:A" because cells in row B, C and D can be null
That's my first problem, the second one is:
I need to return a populated cell before the last one BUT it has to be different than the one that I get from the code above, and also the rows adjacent to it.
I'm sorry if this has been posted before, I tried figuring it out on my own, but I just hit a wall.
Thanks in advance for any help.
---
There you go:
http://docs.google.com/
-----------------------------------------------------------------------------------------
No comments:
Post a Comment