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

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?

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

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))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Melissa" wrote:

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?

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

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

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

--
Biff
Microsoft Excel MVP


"Melissa" wrote in message
...
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?

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

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


Gord Dibben MS Excel MVP


On Tue, 26 Jan 2010 07:45:03 -0800, Melissa
wrote:

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?