C
cheshirekat
I have a workbook with a list on the first worksheet.
The column settings for A are Data Type = Counter.
The count is currently at 25
In column G (7th column) is a number I need in Row 26. (Counter+1)
Basically, I need the last non-blank row of column G for a calculation on a
different worksheet.
I created the first column to be a counter specifically so that I could get
values from other columns by referencing the row with the highest number in
A. I wish I could tell you what made me think I could do this, but I haven't
a clue what I was thinking at the time, and can't figure out a formula now
to save my life.
The only solution I could think of (and in just the last few minutes),
involves two cells on the second worksheet. Like this:
A2 =MAX(FirstSheet!A:A)+1
B2 =INDEX(FirstSheet!A:G,$A$2,7)
I get the value that I'm after, but my 3 tired brain cells tell me that
there must certainly be a way to combine the two formulas into one - you
think?
Thanks,
cheshirekat
The column settings for A are Data Type = Counter.
The count is currently at 25
In column G (7th column) is a number I need in Row 26. (Counter+1)
Basically, I need the last non-blank row of column G for a calculation on a
different worksheet.
I created the first column to be a counter specifically so that I could get
values from other columns by referencing the row with the highest number in
A. I wish I could tell you what made me think I could do this, but I haven't
a clue what I was thinking at the time, and can't figure out a formula now
to save my life.
The only solution I could think of (and in just the last few minutes),
involves two cells on the second worksheet. Like this:
A2 =MAX(FirstSheet!A:A)+1
B2 =INDEX(FirstSheet!A:G,$A$2,7)
I get the value that I'm after, but my 3 tired brain cells tell me that
there must certainly be a way to combine the two formulas into one - you
think?
Thanks,
cheshirekat