Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
croberts
 
Posts: n/a
Default formulation of an expiry summary


I am trying to create a summary sheet in my workbook which
will show the earliest expiry dates for a particular item. The dates
are entered into other worksheets in the workbook and are linked to the
summary worksheet, however the problem that I am finding is that if no
data (date) is entered into a cell under a particular heading on one
of the other worksheets, it is coming up on the summary sheet as
Jan-00. How do I get rid of this ?

The next problem is that I need a formula that will recognise the
earliest expiry date. I have tried the =MIN but because of the current
problem of it reading no data as Jan-00 it will always read this as the
earliest expiry rather than the actual data entered. What can I do, or
what formula is needed to fix this.


Can you please help me with this, as I am lost for an answer from
anyone else.


--
croberts
------------------------------------------------------------------------
croberts's Profile: http://www.excelforum.com/member.php...o&userid=27902
View this thread: http://www.excelforum.com/showthread...hreadid=474023

  #2   Report Post  
Max
 
Posts: n/a
Default

Instead of using links like: =Sheet1!A1
put it as: =IF(Sheet1!A1="","",Sheet1!A1)
That should hopefully clear up both issues
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"croberts" wrote in
message ...

I am trying to create a summary sheet in my workbook which
will show the earliest expiry dates for a particular item. The dates
are entered into other worksheets in the workbook and are linked to the
summary worksheet, however the problem that I am finding is that if no
data (date) is entered into a cell under a particular heading on one
of the other worksheets, it is coming up on the summary sheet as
Jan-00. How do I get rid of this ?

The next problem is that I need a formula that will recognise the
earliest expiry date. I have tried the =MIN but because of the current
problem of it reading no data as Jan-00 it will always read this as the
earliest expiry rather than the actual data entered. What can I do, or
what formula is needed to fix this.


Can you please help me with this, as I am lost for an answer from
anyone else.


--
croberts
------------------------------------------------------------------------
croberts's Profile:

http://www.excelforum.com/member.php...o&userid=27902
View this thread: http://www.excelforum.com/showthread...hreadid=474023



Reply
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
Linking References from Multiple Sheets to One Summary Sheet Kim Setting up and Configuration of Excel 3 May 5th 05 04:56 PM
Same cell added to master summary sheet Bruce Fry Excel Worksheet Functions 0 April 22nd 05 02:11 PM
Filling cells on a summary page Jaytee Excel Worksheet Functions 1 April 12th 05 02:56 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 09:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 08:43 AM


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

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

About Us

"It's about Microsoft Excel"