H
Hud67
Hello
I have a large worksheet with contact details and booking areas (Booking 1,
Booking 2 etc.):
Booking 1
Booking 2
Title Forename Name Area From To Area From
To
Mr Alex Smith Blue 5/1/08 8/7/08 Orange
4/1/08 2/10/09
Ms Vicki Life Orange 8/1/08 15/7/08 Blue
10/1/08 20/10/08
In another excel file (or in another worksheet) i would like to see the name
of the person who has the same entry date and area. See example:
Date Blue Orange
1/01/08
2/01/08
3/01/08
4/01/08 Mr Alex Smith
5/01/08 Mr Alex Smith
6/01/08
7/01/08
8/01/08 Ms Vicki Life
9/01/08
10/01/08 Ms Vicki Life
etc.
I tried it with DGET (it's not the best solution because i have to create a
massive worksheet) What about SUMPRODUCT?
Thanks for your help.
I have a large worksheet with contact details and booking areas (Booking 1,
Booking 2 etc.):
Booking 1
Booking 2
Title Forename Name Area From To Area From
To
Mr Alex Smith Blue 5/1/08 8/7/08 Orange
4/1/08 2/10/09
Ms Vicki Life Orange 8/1/08 15/7/08 Blue
10/1/08 20/10/08
In another excel file (or in another worksheet) i would like to see the name
of the person who has the same entry date and area. See example:
Date Blue Orange
1/01/08
2/01/08
3/01/08
4/01/08 Mr Alex Smith
5/01/08 Mr Alex Smith
6/01/08
7/01/08
8/01/08 Ms Vicki Life
9/01/08
10/01/08 Ms Vicki Life
etc.
I tried it with DGET (it's not the best solution because i have to create a
massive worksheet) What about SUMPRODUCT?
Thanks for your help.