A
aussiegirlone
Dear T. valko
I am sorry for not responding sooner as it just became too much for my
little mind to cope with changing all my formula’s to get the one I want most
to work HMMMM.
However I hope you are still willing to help me? If you are then let me
continue from where we left off.
These two formulas below are what you gave to me last night
The replacement of my original
=IF(OR(Sheet3!B18="A",Sheet3!B25="A",Sheet3!B32="A",Sheet3!B39="A",Sheet3!B46="A"),1,"")
=IF(COUNT(C3),B3-LOOKUP(1E+100,D$22,B$2:B2))
It certainly helped me quite a lot thus, making you to be a very good stress
reliever however there is still one minor problem with the second formula.
It certainly counts the number of days from the first input date and time to
the last input date and time. However, if there is an accident two days in a
row, it should show (0) instead it counts from the previous day only not
from the whole week, month or year. So I only get one day from the last
accident not 2,3,4,5,6, and if there were no accidents for a whole year it
should calculate last accident was 365 days ago.
I am getting exhausted from trying to get this formula so if you gave up on
me it would be quite forgivable, as my little mind can handle that, and I
would just like to say thank you for all your help and to everyone else that
got involved.
PS: I hope your having a good day?
aussiegirlone
B C D E
Date Time Number of Days Since
Accidents last Accident
1/1/2008 12:30 PM 0
2/1/2008 1:00 AM 1 1
3/1/2008 2:30 PM 0
4/1/2008 3:30 PM 0
5/1/2008 4:30 PM 0
6/1/2008 5:30 PM 0
7/1/2008 6:30 pm 1 1
I am sorry for not responding sooner as it just became too much for my
little mind to cope with changing all my formula’s to get the one I want most
to work HMMMM.
However I hope you are still willing to help me? If you are then let me
continue from where we left off.
These two formulas below are what you gave to me last night
The replacement of my original
=IF(OR(Sheet3!B18="A",Sheet3!B25="A",Sheet3!B32="A",Sheet3!B39="A",Sheet3!B46="A"),1,"")
=IF(COUNT(C3),B3-LOOKUP(1E+100,D$22,B$2:B2))
It certainly helped me quite a lot thus, making you to be a very good stress
reliever however there is still one minor problem with the second formula.
It certainly counts the number of days from the first input date and time to
the last input date and time. However, if there is an accident two days in a
row, it should show (0) instead it counts from the previous day only not
from the whole week, month or year. So I only get one day from the last
accident not 2,3,4,5,6, and if there were no accidents for a whole year it
should calculate last accident was 365 days ago.
I am getting exhausted from trying to get this formula so if you gave up on
me it would be quite forgivable, as my little mind can handle that, and I
would just like to say thank you for all your help and to everyone else that
got involved.
PS: I hope your having a good day?
aussiegirlone
B C D E
Date Time Number of Days Since
Accidents last Accident
1/1/2008 12:30 PM 0
2/1/2008 1:00 AM 1 1
3/1/2008 2:30 PM 0
4/1/2008 3:30 PM 0
5/1/2008 4:30 PM 0
6/1/2008 5:30 PM 0
7/1/2008 6:30 pm 1 1