What formula do I use to show the last cell with text in a colum

[Melissa]

I have an Excel worksheet with 2 sheets. Sheet1 is for data entry and will
have data in columns to record details of meetings, each row is a different
person e.g. column B has details of first meeting, column C has details of
second meeting, column D has details of third meeting and so on .

I want my second sheet to be a report that shows the details of the most
recent meeting i.e I want a formula in sheet2 that looks at sheet1, finds the
last cell in a row with text, and copies this text to the relevant cell in
sheet2. Do I use "go to" command plus a formula? how?

 

[Luke M]

Assuming that there is some type of data in column A, could do:
=INDEX(2:2,,COUNTA(2:2))

Otherwise,
=INDEX(B2:Z2,,COUNTA(B2:Z2))

 

[T. Valko]

This formula will return the *last* (rightmost) TEXT entry in the range
B1:J1.

=LOOKUP(REPT("z",255),B1:J1)

 

[Gord Dibben]

=LOOKUP(REPT("z",255),Sheet1!B1:J1)


Gord Dibben MS Excel MVP