Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hi i have a sheet that contains a column with dates from jan to dec which i
have also formated as a table. i have a sheet also formatted as tables representing the 12 months, but in this 2nd sheet the mothns are sprated by 3 merged rows and i want to get the dates enterd in the date sheets to refelect in the second sheet. it does happen when i use =and select the the sheet tab. all i want know is how can i get it so that when there is no date it will not show a zero zero but N/A or nothing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
concatenate tables into html tables | Excel Discussion (Misc queries) | |||
Referencing Two Tables | Excel Discussion (Misc queries) | |||
Avoiding #Value errors when referencing DB Tables | Excel Worksheet Functions | |||
Cross referencing on tables | Excel Discussion (Misc queries) | |||
referencing a different tab by referencing a list in the current s | Excel Worksheet Functions |