Looking for a value in a previous row
 

I am trying to determine a previous row number in a chart like this --
..
..
..
xxx xxx data xxx xxx xxx xxx xxx xxx
xxx xxx xxx xxx

Looking for a value in a previous row
 

If I understand you correctly; the data row will always be filled (especially
ColA,ColB,ColC) and for the current row these columns will not be filled.

In that case; the below code should give you the previous data row. Try and
feedback

Dim lngDataRow as Long
lngDataRow = Cells(Activecell.row, "C").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"ejack" wrote:

I am trying to determine a previous row number in a chart like this --
.
.
.
xxx xxx data xxx xxx xxx xxx xxx xxx
xxx xxx xxx xxx
.
.
.
xxx xxx xxx xxx (how many rows
back to data row?)
.
.
.

I would like to know the contents of the data and other cells in that row in
the lower rows. I can't figure out what key words to search for in the
discussion groups. Your help would be greatly appreciated.

Looking for a value in a previous row
 

"Jacob Skaria" wrote:

If I understand you correctly; the data row will always be filled (especially
ColA,ColB,ColC) and for the current row these columns will not be filled.

In that case; the below code should give you the previous data row. Try and
feedback

Dim lngDataRow as Long
lngDataRow = Cells(Activecell.row, "C").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"ejack" wrote:

I am trying to determine a previous row number in a chart like this --
.
.
.
xxx xxx data xxx xxx xxx xxx xxx xxx
..................................xxx xxx xxx xxx
.
.
.
..................................xxx xxx xxx xxx (how many rows
back to data row?)
.
.
.

I would like to know the contents of the data and other cells in that row in
the lower rows. I can't figure out what key words to search for in the
discussion groups. Your help would be greatly appreciated.

Thanks Jacob, yes, you do understand that the subsequent rows will be
indented essentially. That looks like a basic code call. It has been years
since I had to use basic in my spreadsheets. Do you think it is necessary to
use basic?

Looking for a value in a previous row
 

The below formula will give you the next entry upwards in the range C1:C10..
=LOOKUP(2,1/(C1:C10<""),C1:C10)

So you can apply that in row 11...

If this post helps click Yes
---------------
Jacob Skaria


"ejack" wrote:



"Jacob Skaria" wrote:

If I understand you correctly; the data row will always be filled (especially
ColA,ColB,ColC) and for the current row these columns will not be filled.

In that case; the below code should give you the previous data row. Try and
feedback

Dim lngDataRow as Long
lngDataRow = Cells(Activecell.row, "C").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"ejack" wrote:

I am trying to determine a previous row number in a chart like this --
.
.
.
xxx xxx data xxx xxx xxx xxx xxx xxx
..................................xxx xxx xxx xxx
.
.
.
..................................xxx xxx xxx xxx (how many rows
back to data row?)
.
.
.

I would like to know the contents of the data and other cells in that row in
the lower rows. I can't figure out what key words to search for in the
discussion groups. Your help would be greatly appreciated.

Thanks Jacob, yes, you do understand that the subsequent rows will be
indented essentially. That looks like a basic code call. It has been years
since I had to use basic in my spreadsheets. Do you think it is necessary to
use basic?

Looking for a value in a previous row
 

OK, thanks Jacob. I tweaked it to =LOOKUP(2,1/(R1C1:RC1<""),R1C1:RC1) so it
is general to the current row, thanks again.

"Jacob Skaria" wrote:

The below formula will give you the next entry upwards in the range C1:C10..
=LOOKUP(2,1/(C1:C10<""),C1:C10)

So you can apply that in row 11...

If this post helps click Yes
---------------
Jacob Skaria


"ejack" wrote:



"Jacob Skaria" wrote:

If I understand you correctly; the data row will always be filled (especially
ColA,ColB,ColC) and for the current row these columns will not be filled.

In that case; the below code should give you the previous data row. Try and
feedback

Dim lngDataRow as Long
lngDataRow = Cells(Activecell.row, "C").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"ejack" wrote:

I am trying to determine a previous row number in a chart like this --
.
.
.
xxx xxx data xxx xxx xxx xxx xxx xxx
..................................xxx xxx xxx xxx
.
.
.
..................................xxx xxx xxx xxx (how many rows
back to data row?)
.
.
.

I would like to know the contents of the data and other cells in that row in
the lower rows. I can't figure out what key words to search for in the
discussion groups. Your help would be greatly appreciated.

Thanks Jacob, yes, you do understand that the subsequent rows will be
indented essentially. That looks like a basic code call. It has been years
since I had to use basic in my spreadsheets. Do you think it is necessary to
use basic?