nikhil0311
Board Regular
- Joined
- May 3, 2013
- Messages
- 200
- Office Version
- 2013
- Platform
- Windows
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Input Data | ||||||||
2 | Date | BD | Frequency | Activity | |||||
3 | Friday, November 1, 2019 | 1 | Weekly | Mgmt Report | |||||
4 | Monday, November 4, 2019 | 4 | Weekly | Revenue Report | |||||
5 | Monday, November 4, 2019 | 4 | Weekly | Trade Report | |||||
6 | Tuesday, November 5, 2019 | 5 | Bi Weekly | Forecasting | |||||
7 | Tuesday, November 5, 2019 | 5 | Bi Weekly | Income Statement | |||||
8 | Wednesday, November 6, 2019 | 6 | Weekly | Client Meeting | |||||
9 | Thursday, November 7, 2019 | 7 | Weekly | Mgmt Report APAC | |||||
10 | Friday, November 8, 2019 | 8 | Monthly | Budget Activity | |||||
11 | Friday, November 8, 2019 | 8 | Monthly | Budget Activity APAC | |||||
12 | Friday, November 8, 2019 | 8 | Monthly | Budget Activity EMEA | |||||
13 | Friday, November 8, 2019 | 8 | Monthly | Budget Activity CANADA | |||||
14 | |||||||||
15 | |||||||||
16 | Output Final | ||||||||
17 | Business day | Friday, November 1, 2019 | Monday, November 4, 2019 | Tuesday, November 5, 2019 | Wednesday, November 6, 2019 | Thursday, November 7, 2019 | Friday, November 8, 2019 | ||
18 | Mgmt Report | Revenue Report | Forecasting | Client Meeting | Mgmt Report APAC | Budget Activity | |||
19 | Trade Report | Income Statement | Budget Activity APAC | ||||||
20 | Budget Activity EMEA | ||||||||
21 | Budget Activity CANADA | ||||||||
Sheet1 |
Range A2 to D13 is the input data where we have different dates and activities
What I am looking for is the activites to be listed out in different columns as per the date
for example if we look at the input data i.e. A4:A5, the data is november 4th Monday, based on this we are looking to get the output below cell C17
Thanks in advance. Please let me know if you havd any questions