Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
Show centered text along merged colum cells | Excel Discussion (Misc queries) | |||
Using IF formula to show what text is in the cell from ddown list | Excel Worksheet Functions |