software

I have a large list of data in sheet1, but I want all row(s) that has a
date prior to 05/11/2006 to be displayed in sheet2. Is this possible
with a formula? Thanks.--
exsam21
------------------------------------------------------------------------
exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
View this thread: www.excelforum.com/showthread...hreadid=542175not easily done with a formula
try datagt;filtergt;advanced filter

--
Don Guillett
SalesAid Software

quot;exsam21quot; gt; wrote in
message ...
gt;
gt; I have a large list of data in sheet1, but I want all row(s) that has a
gt; date prior to 05/11/2006 to be displayed in sheet2. Is this possible
gt; with a formula? Thanks.
gt;
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile:
gt; www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=542175
gt;
Does the info have to be displayed in sheet2? If yes, then a formula (in
sheet2)would have to be created for each row in sheet1 that would check the
date. There are functions that can give you a total, ie how many dates are
prior to the date specified. If you can get by with displaying on sheet1,
then I would create a conditional format that would change the color in each
cell that meets the criteria you are looking for and also place a formula in
sheet1 that would give you a total number that meet the criteria.

Hope this helps,
Les

quot;exsam21quot; wrote:

gt;
gt; I have a large list of data in sheet1, but I want all row(s) that has a
gt; date prior to 05/11/2006 to be displayed in sheet2. Is this possible
gt; with a formula? Thanks.
gt;
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=542175
gt;
gt;