Hi,
Please help me with a formula.
I have a wook sheet that comapres In and out dates then returns a Quanity of items needed to the field.
The data only gives an in and out date. The item may be in use for a range of dates. So I would Like the spreadsheet to fill in the quanity between the dates
Example:
AAGEN is in use from 2002/1/1 till 2002/1/4
I want it to show in use also on the 2nd and 3rd.
Item Order 2002 1 1 2002 1 2 2002 1 3 2002 1 4
AAGEN BobSmith 2 2
Here is the current formula
IF(OR(AND($C$1=look!A2, B2=look!C2),AND($C$1=look!B2, B2=look!C2),), look!E2, ""
This sheet is 93 colums by 5000 rows so any help will be appreciated.
Thanks
Allan
Allan@colrotone.com
Please help me with a formula.
I have a wook sheet that comapres In and out dates then returns a Quanity of items needed to the field.
The data only gives an in and out date. The item may be in use for a range of dates. So I would Like the spreadsheet to fill in the quanity between the dates
Example:
AAGEN is in use from 2002/1/1 till 2002/1/4
I want it to show in use also on the 2nd and 3rd.
Item Order 2002 1 1 2002 1 2 2002 1 3 2002 1 4
AAGEN BobSmith 2 2
Here is the current formula
IF(OR(AND($C$1=look!A2, B2=look!C2),AND($C$1=look!B2, B2=look!C2),), look!E2, ""
This sheet is 93 colums by 5000 rows so any help will be appreciated.
Thanks
Allan
Allan@colrotone.com