Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying the same information every week in different cells and preserving data.
Each column displays data in a cell that was pulled from a pivot table
at the end of the week.(friday) I want to preserve the data in cell B43 that I collect for mar.2,2007. On Mar. 9, 2007, the same data will be pulled and placed in C43. I have tried two different functions, but both do not preserve the data. Either nothing is displayed, or it is overwritten with the current date's value. =SUMIF(A1,"="&DATE(2007,3,2),Summary!E14) ...this one will overwrite with the value I obtain from Summary!E14 on Mar. 9. If I remove the sign, "0" is displayed after 3/2/2007. =IF(TODAY()=DATE(2007,3,2),GETPIVOTDATA("mnemonic" ,Summary!$A $2,"status","NOK"),"")...this one will not display anything for a date after 3/2/2007 Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Tuesday's date throughout the week | Excel Worksheet Functions | |||
searching cells - displaying data | Excel Discussion (Misc queries) | |||
Retrieving information for a day of the week... | Excel Worksheet Functions | |||
Preserving hyperlinks in linked cells | Excel Discussion (Misc queries) | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions |