This is driving me nuts .. I have a 2-column set of numbers cols (G-H)and the number
of rows in the column is varied by a user macro - so I know how many rows are in the column
I want cell C10 to always display the value of the last row in the column using formula (not VBA)
I know this is simple .. but its driving me mad .. what is the formula to get the contents of a cell in column H row X - where x = the number of rows the user has chosen
thanks
Bill
of rows in the column is varied by a user macro - so I know how many rows are in the column
I want cell C10 to always display the value of the last row in the column using formula (not VBA)
I know this is simple .. but its driving me mad .. what is the formula to get the contents of a cell in column H row X - where x = the number of rows the user has chosen
thanks
Bill