Dear friends,
I required your help for the below excel query:
The following is the data set sample:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I require the course name based if two criteria are met:
a) Reg no
b) Data range is within category from the below data set:
Reg no From To Course
123456 1/05/2017 26/05/2017 Maths
123456 27/05/2017 31/05/2017 Geography
901999 1/05/2017 15/06/2017 Science
901999 16/06/2017 30/06/2017 History
Based on the below, the final data set with course name should be as follows:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Hope its clear. Thanks
Rahmit
I required your help for the below excel query:
The following is the data set sample:
Class. Date | Reg.No | Course |
12/05/2017 | 123456 | ? |
19/05/2017 | 123456 | ? |
30/05/2017 | 123456 | ? |
02/06/2017 | 901999 | ? |
09/06/2017 | 901999 | ? |
16/06/2017 | 901999 | ? |
23/06/2017 | 901999 | ? |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I require the course name based if two criteria are met:
a) Reg no
b) Data range is within category from the below data set:
Reg no From To Course
123456 1/05/2017 26/05/2017 Maths
123456 27/05/2017 31/05/2017 Geography
901999 1/05/2017 15/06/2017 Science
901999 16/06/2017 30/06/2017 History
Based on the below, the final data set with course name should be as follows:
Class. Date | Reg.No | Course |
12/05/2017 | 123456 | Maths |
19/05/2017 | 123456 | Maths |
30/05/2017 | 123456 | Geography |
02/06/2017 | 901999 | Science |
09/06/2017 | 901999 | Science |
16/06/2017 | 901999 | History |
23/06/2017 | 901999 | History |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Hope its clear. Thanks
Rahmit