Problems with comparing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I hope somebody can help me with the following problem

I have a spreadsheet that shows when I received certain parts. The columns are: date received and partnumber and description part. Every year I have to do a time study on every partnumber. Parts are received at least once a month

I would like to compare a partnumber and date received that I just entered with the rest of the data. I need to know whether a time study was done in the last 9 months on a certain part, and if not I would like to see a reminder that i still need to do a time study for this part

How can I do this

I appreciate your hel

Jeff
 
Hi
you may provide some more detail about your spreadsheet layout. Best
would be you post some example rows (plain text - no attachment please)
and describe your expected result based on this example data
 
An example of the column names and data are

date received Item code quantity unit price tota
3/22/03 Roofing nails 29-0074 1200 $ 0.25 $ 30
8/01/03 2 1/2 staples 26-0159 66300 $ 0.17 $ 11,27
1/16/04 Roofing nails 29-0074 2000 $ 0.25 $ 50

Our organization has to do a required time study on each item once per year. That means that each item is being tested. The items are being entered in the spreadsheet on the day that they are received and the list contains items of at least 1 year long. Some items are being received once or twice a month, others once every 4 months. What I would like to happen is that when I enter a new item in the spreadsheet, I want to know if this item is due for a time study. If possible I would like to know this 3 month before the deadline for the time study (which is 1 year from the previous time study). If possible I would like to see a pop up appear that tells me that item "XXXX" is due for a time study

How can I do this?
 
Hi Jeff
and where do you store that an item has been tested. There should be a
second sheet where you enter this information?
 
Hi
popup message would be a little difficult but you could flag the
entries with a color for example. e.g. to color all rows which have an
old entry date. Try the following:
- select your range (e.g. A1:F1000) 7 col. a is the date column
- goto 'Format - Conditional Format')
- enter the formula:
=$A1<=DATE(YEAR(TODAY()-1),MONTH(TODAY()),DAY(TODAY()))
- choose a format for these entries.
 
Back
Top