Formula Question

I have built a workbook in which I have inserted a formula to tell me whether
the contents of a supply bin needs replenishment or not. The formula I used
is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to see
what parts have been used, which becomes a new sheet in the workbook.

Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
back through the workbook to count whether that same part needed
replenishment on consecutive previous days. If it has, then the latest
worksheet will report the number of days that part that part has been in need
of replenishment.

Can you help me?

Would be nice if you told us more about the workbook. Like were is the data
for each day of the week? - on the same worksheet or on its own worksheet.
Tell us what we need to help you.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"blackgold21" <blackgold21@discussions.microsoft.com> wrote in message
news:BD934AFF-34D0-45DB-9F30-20172EFBAA64@microsoft.com...
>I have built a workbook in which I have inserted a formula to tell me
>whether
> the contents of a supply bin needs replenishment or not. The formula I
> used
> is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to
> see
> what parts have been used, which becomes a new sheet in the workbook.
>
> Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
> back through the workbook to count whether that same part needed
> replenishment on consecutive previous days. If it has, then the latest
> worksheet will report the number of days that part that part has been in
> need
> of replenishment.
>
> Can you help me?

Sorry if my description was unclear. Each day's report becomes a new sheet
in the same workbook

"Bernard Liengme" wrote:

> Would be nice if you told us more about the workbook. Like were is the data
> for each day of the week? - on the same worksheet or on its own worksheet.
> Tell us what we need to help you.
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "blackgold21" <blackgold21@discussions.microsoft.com> wrote in message
> news:BD934AFF-34D0-45DB-9F30-20172EFBAA64@microsoft.com...
> >I have built a workbook in which I have inserted a formula to tell me
> >whether
> > the contents of a supply bin needs replenishment or not. The formula I
> > used
> > is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to
> > see
> > what parts have been used, which becomes a new sheet in the workbook.
> >
> > Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
> > back through the workbook to count whether that same part needed
> > replenishment on consecutive previous days. If it has, then the latest
> > worksheet will report the number of days that part that part has been in
> > need
> > of replenishment.
> >
> > Can you help me?
>
>
>

WOULD ANYONE ELSE CARE TO TAKE A STAB AT THIS QUESTION--PLEASE??

"blackgold21" wrote:

> Sorry if my description was unclear. Each day's report becomes a new sheet
> in the same workbook
>
> "Bernard Liengme" wrote:
>
> > Would be nice if you told us more about the workbook. Like were is the data
> > for each day of the week? - on the same worksheet or on its own worksheet.
> > Tell us what we need to help you.
> > --
> > Bernard V Liengme
> > www.stfx.ca/people/bliengme
> > remove caps from email
> >
> > "blackgold21" <blackgold21@discussions.microsoft.com> wrote in message
> > news:BD934AFF-34D0-45DB-9F30-20172EFBAA64@microsoft.com...
> > >I have built a workbook in which I have inserted a formula to tell me
> > >whether
> > > the contents of a supply bin needs replenishment or not. The formula I
> > > used
> > > is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to
> > > see
> > > what parts have been used, which becomes a new sheet in the workbook.
> > >
> > > Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
> > > back through the workbook to count whether that same part needed
> > > replenishment on consecutive previous days. If it has, then the latest
> > > worksheet will report the number of days that part that part has been in
> > > need
> > > of replenishment.
> > >
> > > Can you help me?
> >
> >
> >

each days workbook has different data?If the same part number is replenished
they will be in a different cell on each day?.Each day has a completely
different sized data range?,How is each worksheet named?Give us a couple of
examples of data,say the position of the example part number that did need
replenishing say three days in a row,where is it on the sheet,how is the dta
arranged what does the surrounding data look like?
--
paul
remove nospam for email addy!



"blackgold21" wrote:

> WOULD ANYONE ELSE CARE TO TAKE A STAB AT THIS QUESTION--PLEASE??
>
> "blackgold21" wrote:
>
> > Sorry if my description was unclear. Each day's report becomes a new sheet
> > in the same workbook
> >
> > "Bernard Liengme" wrote:
> >
> > > Would be nice if you told us more about the workbook. Like were is the data
> > > for each day of the week? - on the same worksheet or on its own worksheet.
> > > Tell us what we need to help you.
> > > --
> > > Bernard V Liengme
> > > www.stfx.ca/people/bliengme
> > > remove caps from email
> > >
> > > "blackgold21" <blackgold21@discussions.microsoft.com> wrote in message
> > > news:BD934AFF-34D0-45DB-9F30-20172EFBAA64@microsoft.com...
> > > >I have built a workbook in which I have inserted a formula to tell me
> > > >whether
> > > > the contents of a supply bin needs replenishment or not. The formula I
> > > > used
> > > > is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to
> > > > see
> > > > what parts have been used, which becomes a new sheet in the workbook.
> > > >
> > > > Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
> > > > back through the workbook to count whether that same part needed
> > > > replenishment on consecutive previous days. If it has, then the latest
> > > > worksheet will report the number of days that part that part has been in
> > > > need
> > > > of replenishment.
> > > >
> > > > Can you help me?
> > >
> > >
> > >

Paul,

The list of parts is static (it is a standing inventory of parts for which I
have an agreement with vendors to replenish when needed); only the status is
dynamic. Therefore each day's worksheet has pretty much the same data range.
Worksheets are named for days of the year (i.e., 20050824, 200050825,
20050826, etc.)
As for examples of data, here is a try for a data range of the same 4
columns x 5 rows on each worksheet. Column header "MIN ORQ" represents
(Minimum Onhand Requirement). "R.L.T." represents (Replenishment Lag Time,
the formula I need help with):

(sheet 20050824)
MIN ORQ ON HAND ACTION R. L. T.
90 6 REPLENISH!
44 90 No Action
2000 907 REPLENISH!
1200 2122 No Action

(sheet 20050825)
MIN ORQ ON HAND ACTION R. L. T.
90 6 REPLENISH!
44 20 REPLENISH!
2000 907 REPLENISH!
1200 2000 No Action

(sheet 20050826)
MIN ORQ ON HAND ACTION R. L. T.
90 160 No Action
44 12 REPLENISH!
2000 2100 No Action
1200 24 REPLENISH!


"paul" wrote:

> each days workbook has different data?If the same part number is replenished
> they will be in a different cell on each day?.Each day has a completely
> different sized data range?,How is each worksheet named?Give us a couple of
> examples of data,say the position of the example part number that did need
> replenishing say three days in a row,where is it on the sheet,how is the dta
> arranged what does the surrounding data look like?
> --
> paul
> remove nospam for email addy!
>
>
>
> "blackgold21" wrote:
>
> > WOULD ANYONE ELSE CARE TO TAKE A STAB AT THIS QUESTION--PLEASE??
> >
> > "blackgold21" wrote:
> >
> > > Sorry if my description was unclear. Each day's report becomes a new sheet
> > > in the same workbook
> > >
> > > "Bernard Liengme" wrote:
> > >
> > > > Would be nice if you told us more about the workbook. Like were is the data
> > > > for each day of the week? - on the same worksheet or on its own worksheet.
> > > > Tell us what we need to help you.
> > > > --
> > > > Bernard V Liengme
> > > > www.stfx.ca/people/bliengme
> > > > remove caps from email
> > > >
> > > > "blackgold21" <blackgold21@discussions.microsoft.com> wrote in message
> > > > news:BD934AFF-34D0-45DB-9F30-20172EFBAA64@microsoft.com...
> > > > >I have built a workbook in which I have inserted a formula to tell me
> > > > >whether
> > > > > the contents of a supply bin needs replenishment or not. The formula I
> > > > > used
> > > > > is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to
> > > > > see
> > > > > what parts have been used, which becomes a new sheet in the workbook.
> > > > >
> > > > > Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
> > > > > back through the workbook to count whether that same part needed
> > > > > replenishment on consecutive previous days. If it has, then the latest
> > > > > worksheet will report the number of days that part that part has been in
> > > > > need
> > > > > of replenishment.
> > > > >
> > > > > Can you help me?
> > > >
> > > >
> > > >