Joe,
Just a follow-up. I was able to fix him up off line, your condensed formula
was major help. The formula we ended up using for row 2 was:
=IF(E2=E3,IF(F2=F3,1,2),IF(F2=F3,4,3))
and with a little VBA, a new row 2 with that formula set up along with 5 & 9
day averages are provided for him at the click of a button on the sheet.

Much to his credit, he has gone out and obtained a copy of Excel 2003 for
Dummies (the one by Walkenbach), and that should be a help to him. I think
one thing he hadn't discovered at the point of this thread was just how much
Help Excel's help can actually be in assisting in understanding the syntax of
worksheet functions.

"Joe User" wrote:

"Joe User" <joeu2004 wrote:
Can you send your Excel file to me?

He did, and I helped him as much as I am willing to do. All I did was apply
the suggestions of JLatham's and mine exactly as we had instructed. This is
m.p.e.newusers, but I draw the line at holding the OP's hand and pressing
each keystroke.

Based on our exchange of email, it sounds like "Omocron" is looking for
continued assistance. If anyone is interested, please step up.


----- original message -----

"Joe User" <joeu2004 wrote in message
...
"omocron" wrote:
If need be, let me know what time you will
be here so I can open my profile and let you
see my email...(briefly).

Not clear on how that would work.

Can you send your Excel file to me? It needs to be Excel 2003 or earlier
(or XL2007 saved in compatibility mode). And it should not depend on data
in
external files.

If you're amenable to that, send the Excel file to joeu2004 "at"
hotmail.com. The Subject line should refer to this thread. And it might
be
help to include some explanation or pointers in the body of the email.


----- original message -----

"omocron" wrote:
JLatham, Let me just ask bluntly, Is there a way or email address where
I
could go into further detail about this. I frankly don't mind inviting
Joe
User into the conversation as well, however I don't know protocol or what
is
acceptable here in this forum.

Without sounding too mysterious, I would like to use a close scenario to
what I am trying to accomplish. I think this would be beneficial to me
and
would also help you understand what I am trying to make these figures do.
If
you don't care to send a way to contact you, I understand. No offense
taken.
Same for you Joe User.

I plugged in the formula into a trial database and it doesn't appear to
be
working. Could be a prob on my part, but it could also be in the formula
as
I don't think the column is updating each day. It appears that when a
new
value is placed in the H column, it changes all info in that column to
the
same value. This should be a new value each day and then as the data is
brought in each day, it should remain static for each day and the new
data
value be placed at the top of the column under THAT days row. (H) The
top
row should always be Today's Data and tomorrow it should move to the
second
line and Data from tomorrow becomes the top row.

I'm not trying to make this complicated however I'm not wanting to put
ALL
of my business out on the forum either. So......I'll wait to hear from
you
....and Joe User and see if there is a way I can further go into detail
about
this.

By the way....Column H is a preset value.....think of it like this....E
and
F are two differing amounts gained from the days data. If E is higher
the
value assigned to H will be either 1 or 2 depending what F did. If E is
lower, the value assigned to H will be either 3 or 4 depending on what F
did
(higher or lower). The values for H are assigned depending on what E and
F
in combination have done. (higher,higher....higher,lower......lower,
higher....and lower, lower. Those are the only values that will be
assigned.
1,2,3, or 4...in that order.
And then, what I want to do is keep a running average (simple) in column'
I
' so I can see what the last 5 days value average is.

If need be, let me know what time you will be here so I can open my
profile
and let you see my email...(briefly)....so we might be able to
communicate
under less glaring light...LOL
If not, I'll try my best to do as you have recommended and see if this
can
come to pass. Thanks...much appreciated.
--
Omocron


"JLatham" wrote:

Second try. This time assuming that the latest/current date is on top
of the
list (at row 2). Also correcting what I think are a couple of minor
errors
in your description of things:
First test, 2nd half you said to compare F to E, but I think you meant
to
compare E to E and F to F. This formula does that.

In the 3rd part you said "the value of column F is less than the value
of
column F from the day before". I think you meant "..is less than OR
EQUAL to
the value..." and again, this formula makes that assumption. NOTE that
my
previous formula did not make this assumption.

Put this formula in H2:
=IF(AND(E2<=E3,F2<=F3),3,IF(AND(E2<=E3,F2F3),4,IF (AND(E2E3,F2<=F3),2,IF(AND(E2E3,F2F3),1,0))))
remember that is all in a continuous entry/line.

You can fill that down the sheet as far as you need to. Again for the
5 day
average, in I2 you can put =AVERAGE(H2:H6) and fill that down to the
5th row
from the bottom of the entries in column H.

Hope this helps.
"omocron" wrote:

First, let me apologise for my lack of Excel knowlege. I have tried
to teach
myself to create this formula on my Excel 2002, however....I give. I
humbly
ask for someone's help.

Column A will be the current date...then there will be 6 columns of
data.
I need to have a formula which will do the following....

If the value of column E is equal to or less than column E's value
from the
day before, and the value of Column F is equal to or less than Column
E's
value from the day before, assign a value of 3 to Column H.

If the value of column E is equal to or less than column E's value
from the
day before (the row under), and the value of Column F is greater than
the
value of Column F from the day before, assign a value of 4 to Column
H.

If the value of column E is greater than column E's value from the
day
before (the row under), and the value of Column F is less than the
value of
Column F from the day before, assign a value of 2 to Column H.

If the value of column E is greater than column E's value from the
day
before (the row under), and the value of Column F is greater than the
value
of Column F from the day before, assign a value of 1 to Column H.

Once these are in place I will want Column H to run a 5 day running
simple
average in Column I.

There will be more later, however these are the most pressing needs I
have
at the current time and rather than spend another month trying to
teach
myself how to do this, I feel my efforts can be better used in other
areas if
I can find the help to have these formula's put into Excel 2002. Any
assistance would be greatly appreciated.
I have used Excel as a Spreadsheet, however never as a database (and
I'm no
expert at using it as a spreadsheet by a long way) Thanks in advance,
and
remember I'm pretty green so take nothing for granted.
--
Omocron

.