Thursday, December 26, 2013

yogi_Return Last 3 Unique Entries From Column A Of Raw_Data And Corresponding Values In # Adjacent Columns To The Right

                                          Google Spreadsheet   Post  #1450
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-26, 2013
question by Jaxiu (!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:


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: