+ Reply to Thread
Results 1 to 2 of 2

formulation of an expiry summary

  1. #1
    Registered User
    Join Date
    10-06-2005
    Posts
    1

    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.

  2. #2
    Max
    Guest

    Re: formulation of an expiry summary

    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" <croberts.1wiked_1128657939.007@excelforum-nospam.com> wrote in
    message news:croberts.1wiked_1128657939.007@excelforum-nospam.com...
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1