LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default referencing in tables

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenate tables into html tables urlocaljeweler Excel Discussion (Misc queries) 1 December 11th 09 08:15 PM
Referencing Two Tables RedFive Excel Discussion (Misc queries) 1 December 1st 08 08:22 PM
Avoiding #Value errors when referencing DB Tables Jeff Metcalf Excel Worksheet Functions 2 May 28th 08 04:52 PM
Cross referencing on tables Rich B[_2_] Excel Discussion (Misc queries) 2 October 2nd 07 10:22 AM
referencing a different tab by referencing a list in the current s Kevin Excel Worksheet Functions 3 July 6th 07 07:57 PM


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"