find data

[crapit]

How do I get the group column in spreadsheet 'group' by using date column
values that falls b/w start and end column in spreadsheet 'data' ???

Spreadsheet 'group'
date group
13.jun.09 AAA <13.jun.09 is b/w 01.feb.09 & 22.jan.10 >
03.nov.09 BBB <03.nov.09 is b/w 20.jan.09 & 13.feb.10 >



Spreadsheet 'data'
start end groupname
01.feb.09 22.jan.10 AAA
20.jan.09 13.feb.10 BBB

 

[Benito Merino]

How do I get the group column in spreadsheet 'group' by using date column
values that falls b/w start and end column in spreadsheet 'data' ???

Spreadsheet 'group'
date               group
13.jun.09       AAA <13.jun.09 is b/w 01.feb.09 &  22.jan.10 >
03.nov.09      BBB  <03.nov.09 is b/w 20.jan.09  &  13.feb.10>

Spreadsheet 'data'
start                end            groupname
01.feb.09    22.jan.10          AAA
20.jan.09    13.feb.10          BBB

Hello Crapit.

I don't know if the example has a mistake (13.jun.09 can be in both
groups). If not, How could I know your rules?

 

[crapit]

Oops,
This the correct sample

Spreadsheet 'group'
date group
13.jun.09 AAA <13.jun.09 is b/w 01.feb.09 & 22.jan.10 >
03.nov.10 BBB <03.nov.09 is b/w 23.jan.09 & 13.feb.10 >



Spreadsheet 'data'
start end groupname
01.feb.09 22.jan.10 AAA
23.jan.09 13.feb.10 BBB

How do I get the group column in spreadsheet 'group' by using date column
values that falls b/w start and end column in spreadsheet 'data' ???

Spreadsheet 'group'
date group
13.jun.09 AAA <13.jun.09 is b/w 01.feb.09 & 22.jan.10 >
03.nov.09 BBB <03.nov.09 is b/w 20.jan.09 & 13.feb.10 >

Spreadsheet 'data'
start end groupname
01.feb.09 22.jan.10 AAA
20.jan.09 13.feb.10 BBB

Hello Crapit.

I don't know if the example has a mistake (13.jun.09 can be in both
groups). If not, How could I know your rules?

 

[crapit]

Stil no answer?

Oops,
This the correct sample

Spreadsheet 'group'
date group
13.jun.09 AAA <13.jun.09 is b/w 01.feb.09 & 22.jan.10 >
03.nov.10 BBB <03.nov.09 is b/w 23.jan.09 & 13.feb.10 >



Spreadsheet 'data'
start end groupname
01.feb.09 22.jan.10 AAA
23.jan.09 13.feb.10 BBB



Hello Crapit.

I don't know if the example has a mistake (13.jun.09 can be in both
groups). If not, How could I know your rules?

 

[Pete_UK]

You might have meant to provide some corrected sample data, but it
looks the same as in your first post. The only difference is that you
now have 03.nov.10 in your "group" data, but this is not consistent
with your comments nor with your "data" sheet.

Please try to be more precise and accurate in your postings, and
explain more fully what you want to achieve.

Pete

 

[herochenna]

Visit www.ExcelGoodies.Com