Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed to find a formula
Hi,
I need help to write a formula that will display all results for two sets of criteria split across two worksheets. Where Worksheet 1 displays Column A Therapist Name, Column F-L Days of the week they will work Column M-T Treatments they will perform Worksheet 2 displays Column F Day of a party booking (in the form of a day of the week) Column I-M treatments used at the party. I need a formula to give me all matching Therapist names (from Worksheet 1) who will work on the day of the week of the party booking (from Worksheet 2), who will perform the treatments that will be used at the party. The results are to be displayed on a third worksheet in the form of Column N Available Therapist 1 Column O Available Therapist 2 Column P Available Therapist 3 and so on Thanks for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed to find a formula
In your instance here, think its easier to see things if you could upload
your sample* using a free filehost, then post a link to it here *Desensitized as appropriate For example, you could use this free filehost to upload: http://www.freefilehosting.net/ Copy the "direct link" which is generated after you upload, then paste it here -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed to find a formula
Hello.
Have a look at the file, here : http://www.filedropper.com/jodie I added intermediate formulae on sheet 1, column V. Regards. Daniel Hi, I need help to write a formula that will display all results for two sets of criteria split across two worksheets. Where Worksheet 1 displays Column A Therapist Name, Column F-L Days of the week they will work Column M-T Treatments they will perform Worksheet 2 displays Column F Day of a party booking (in the form of a day of the week) Column I-M treatments used at the party. I need a formula to give me all matching Therapist names (from Worksheet 1) who will work on the day of the week of the party booking (from Worksheet 2), who will perform the treatments that will be used at the party. The results are to be displayed on a third worksheet in the form of Column N Available Therapist 1 Column O Available Therapist 2 Column P Available Therapist 3 and so on Thanks for any help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed to find a formula
That's almost what I need, many thanks...
But, how do I get it to display the names of all matching instances, rathar then the count of matching instances? Jodie "Daniel.C" wrote: Hello. Have a look at the file, here : http://www.filedropper.com/jodie I added intermediate formulae on sheet 1, column V. Regards. Daniel Hi, I need help to write a formula that will display all results for two sets of criteria split across two worksheets. Where Worksheet 1 displays Column A Therapist Name, Column F-L Days of the week they will work Column M-T Treatments they will perform Worksheet 2 displays Column F Day of a party booking (in the form of a day of the week) Column I-M treatments used at the party. I need a formula to give me all matching Therapist names (from Worksheet 1) who will work on the day of the week of the party booking (from Worksheet 2), who will perform the treatments that will be used at the party. The results are to be displayed on a third worksheet in the form of Column N Available Therapist 1 Column O Available Therapist 2 Column P Available Therapist 3 and so on Thanks for any help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed to find a formula
You have them on Sheet3 from N1.
Daniel That's almost what I need, many thanks... But, how do I get it to display the names of all matching instances, rathar then the count of matching instances? Jodie "Daniel.C" wrote: Hello. Have a look at the file, here : http://www.filedropper.com/jodie I added intermediate formulae on sheet 1, column V. Regards. Daniel Hi, I need help to write a formula that will display all results for two sets of criteria split across two worksheets. Where Worksheet 1 displays Column A Therapist Name, Column F-L Days of the week they will work Column M-T Treatments they will perform Worksheet 2 displays Column F Day of a party booking (in the form of a day of the week) Column I-M treatments used at the party. I need a formula to give me all matching Therapist names (from Worksheet 1) who will work on the day of the week of the party booking (from Worksheet 2), who will perform the treatments that will be used at the party. The results are to be displayed on a third worksheet in the form of Column N Available Therapist 1 Column O Available Therapist 2 Column P Available Therapist 3 and so on Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND formula help needed | Excel Discussion (Misc queries) | |||
Macro needed (like find) | Excel Discussion (Misc queries) | |||
FIND and REPLACE characters needed | New Users to Excel | |||
FIND and REPLACE characters needed | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) |