Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display last status information
Dear all,
I'd like to display last status of my projects in sheet2 based on data on sheet1 as follows: SHEET1: Project Day1 Day2 Day3 Day4 Day5 Day6 Day7 X Status1 Status2 Status3 Y Status1 Status2 Status3 Status4 Status5 SHEET2: Last Status Information: X Status3 Y Status5 Can someone help me, please...? Thank you. rgds js |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display last status information
Hi,
Use the following formula in cell B2 of sheet2 (if the status is a numeric field). LOOKUP(99^99,Sheet1!B11:H11) Use the following formula in cell B2 of sheet2 (if the status is a non-numeric field) LOOKUP(REPT("z",255),Sheet1!B11:H11) Once you have used either of these formulas, just copy it down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "js" wrote in message ... Dear all, I'd like to display last status of my projects in sheet2 based on data on sheet1 as follows: SHEET1: Project Day1 Day2 Day3 Day4 Day5 Day6 Day7 X Status1 Status2 Status3 Y Status1 Status2 Status3 Status4 Status5 SHEET2: Last Status Information: X Status3 Y Status5 Can someone help me, please...? Thank you. rgds js |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display last status information
Hi,
It's work. Thank you very much. rgds js "Ashish Mathur" wrote: Hi, Use the following formula in cell B2 of sheet2 (if the status is a numeric field). LOOKUP(99^99,Sheet1!B11:H11) Use the following formula in cell B2 of sheet2 (if the status is a non-numeric field) LOOKUP(REPT("z",255),Sheet1!B11:H11) Once you have used either of these formulas, just copy it down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "js" wrote in message ... Dear all, I'd like to display last status of my projects in sheet2 based on data on sheet1 as follows: SHEET1: Project Day1 Day2 Day3 Day4 Day5 Day6 Day7 X Status1 Status2 Status3 Y Status1 Status2 Status3 Status4 Status5 SHEET2: Last Status Information: X Status3 Y Status5 Can someone help me, please...? Thank you. rgds js |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display character count on the status bar? | Excel Worksheet Functions | |||
How can I display status bar value in Excel 2007 | Excel Discussion (Misc queries) | |||
display status bar value in excel userform? | Excel Discussion (Misc queries) | |||
Status bar does not display filter mode | Excel Discussion (Misc queries) | |||
Display No. of Rows in Status Bar | Excel Discussion (Misc queries) |