| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
| need previous row help | Excel Programming | |||
| previous day | Excel Programming | |||
| Previous Month End | Excel Discussion (Misc queries) | |||
| Previous Worksheet | Excel Programming | |||
Linear Mode
