Text Displayed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a cell to display the last entry (of text) in a column,
regardless of what the text says...and have it update daily as more rows are
added to the column, and as the text entry may change...based on the formula?

Can anyone assist me with this?

Tom
 
Assuming there are no gaps in the data in column A, this will display the
last entry:

=OFFSET(A1,COUNTA(A:A)-1,0)

Regards

Trevor
 
How do I eliminate the blank lines displayed by the formula in the ceels of
that column?

The formula is this: =IF(GA264="","",IF(AND(GA264<=0,
GB264<=0),"Go",IF(AND(GA264>=100, GB264>=97),"Stop",GG263)))

Right now I am getting a blank cell as a response.

Tom
 
Thanks !!

Trevor Shuttleworth said:
Assuming there are no gaps in the data in column A, this will display the
last entry:

=OFFSET(A1,COUNTA(A:A)-1,0)

Regards

Trevor
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Comparison of columns using Conditional Formatting 3
Help with function on LOOKUP with Text 2
MS Access Sub form display with all entries 1
formula for displaying only the last entry of a group of cells 2
Copy last entry of column to bottom of column 3
text to column 1
Conditional SUM 2

Back
Top