Thread
:
Last Cell in a Column Value
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 2
Last Cell in a Column Value
Thank you so much! It was exactly what I needed :-)
Lori wrote:
If the client were on sheet2 try:
=LOOKUP(9E+99,Sheet2!F:F)
If you already have a list of sheet names from the hyperlinks in column
A you could fill down:
="=LOOKUP(9E+99,'"&A:A&"'!F:F)"
Then select the column copy and paste values and choose Text to Columns
Finish to evaluate.
wrote:
I am creating a Accounts Receivable workbook. I have a worksheet for
each client. On the first sheet of the workbook, I have created a
hyperlink to each client's records. I want to list the balance on the
main sheet as well. This requires the last cell with a value in the
Column (F, in this case) to be displayed, because each client has a
running total. Please help me with the formula to achieve these
results. Thank you in advance for any assistance.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]