Transferring Info from one chart to another if meets certain crite

L

Lee

I have a master chart (info below) that has day age of a certain product.
When that product gets a certain age (range of 15-26 days) I want that
information to show up on another chart within the same worksheet. It will
go away when it gets older than 26 days. Any help is appreciated.

Product # Name date age
90382 Pen 1/30/2009 4
32532 Pencil 1/19/2009 15
31532 crayons 1/25/2009 9
313541 Paper 1/10/2009 24
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top