| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide results
I am putting together a summary spreadsheet of dates from seperate worksheets
in an excel file. In the summary sheet I reference the 'end' date from the summary sheet. If there is no date in the original file, what formula can I use to leave that cell blank/hide on the summary sheet? The way I have it now the results show the default of 1/0/1900 Here is the formula used to reference the info from. =Summary!K5 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide results
=IF(Summary!K5="","",Summary!K5)
-- David Biddulph "bigred72" wrote in message ... I am putting together a summary spreadsheet of dates from seperate worksheets in an excel file. In the summary sheet I reference the 'end' date from the summary sheet. If there is no date in the original file, what formula can I use to leave that cell blank/hide on the summary sheet? The way I have it now the results show the default of 1/0/1900 Here is the formula used to reference the info from. =Summary!K5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide results when cell value is 0 due to linking worksheets | Excel Discussion (Misc queries) | |||
| how can i hide zero results row in a pivot table? | Excel Discussion (Misc queries) | |||
| autofilter does not hide unwanted results | Excel Worksheet Functions | |||
| Want to show/hide cells depending on other cells results | Excel Discussion (Misc queries) | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
Linear Mode
