find data

  • Thread starter Thread starter crapit
  • Start date Start date
C

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
 
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
Click to expand...

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?
 
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
Click to expand...

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?
 
Stil no answer?


crapit said:
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?
Click to expand...
 
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
 
Back
Top