How to determine the score?

E

Eric

There are given data
Under column A, there is a date.
Under column B, there is a score
Under column C, there is a date.
Under column D, there is a score

24-Dec-07 13% 28-Dec-07 31% [row 1]
31-Dec-07 66% 29-Dec-07 48% [row 2]
07-Jan-08 78% 30-Dec-07 15% [row 3]
14-Jan-08 47% 31-Dec-07 96% [row 4]
21-Jan-08 100% 01-Jan-08 33% [row 5]
28-Jan-08 61% 02-Jan-08 62% [row 6]
04-Feb-08 97% 03-Jan-08 65% [row 7]

I would like to retrieve the score under column B into cell E1, where the
date in cell C1 is equal and between the periods in column A, such as 13%
should be return in cell E1, another example, 66% should be returned in cell
E5, because the date in cell C5 is 01-Jan-08, which is between 31-Dec-07 and
07-Jan-08. Through this process, I would like to determine all score under
column E.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
S

Sandy Mann

Eric,

I don't understand your criteria:
should be return in cell E1, another example, 66% should be returned in
cell
E5, because the date in cell C5 is 01-Jan-08, which is between 31-Dec-07
and
07-Jan-08.

I assume that you mean the 31-Dec-07 in cell A2 and the 07-Jan-08 in Cell
A3. If that is so then the 29-Dec-07 is between the 24-Dec-07 in Cell A1
and the 31-Dec-07 in cell A3 aslo so should E2 not have 13% as well?


--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Eric said:
There are given data
Under column A, there is a date.
Under column B, there is a score
Under column C, there is a date.
Under column D, there is a score

24-Dec-07 13% 28-Dec-07 31% [row 1]
31-Dec-07 66% 29-Dec-07 48% [row 2]
07-Jan-08 78% 30-Dec-07 15% [row 3]
14-Jan-08 47% 31-Dec-07 96% [row 4]
21-Jan-08 100% 01-Jan-08 33% [row 5]
28-Jan-08 61% 02-Jan-08 62% [row 6]
04-Feb-08 97% 03-Jan-08 65% [row 7]

I would like to retrieve the score under column B into cell E1, where the
date in cell C1 is equal and between the periods in column A, such as 13%
should be return in cell E1, another example, 66% should be returned in
cell
E5, because the date in cell C5 is 01-Jan-08, which is between 31-Dec-07
and
07-Jan-08. Through this process, I would like to determine all score
under
column E.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the value? 1
How to determine the value? 2
Reverse Index Match 2
How to select the date? 4
Date Comparison Formula 1
macro help 1
How to avergage colums 7
how to use if statements or vlookups 0

Top