Remember Me?

#1
October 7th 05, 04:19 AM
 croberts Posts: n/a
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.

anyone else.

--
croberts
------------------------------------------------------------------------
croberts's Profile: http://www.excelforum.com/member.php...o&userid=27902

#2
October 7th 05, 06:30 PM
 Max Posts: n/a

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.

anyone else.

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

http://www.excelforum.com/member.php...o&userid=27902

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Kim Setting up and Configuration of Excel 3 May 5th 05 04:56 PM Bruce Fry Excel Worksheet Functions 0 April 22nd 05 02:11 PM Jaytee Excel Worksheet Functions 1 April 12th 05 02:56 PM gambinijr Excel Discussion (Misc queries) 4 December 16th 04 09:13 PM greg g Excel Discussion (Misc queries) 1 December 16th 04 08:43 AM

All times are GMT +1. The time now is 07:59 PM.