I have data like this.
HRM 2014 Q1
HRM 2015 Q1
HRM 2015 Q2
HRM 2015 Q2
HRM 2015 Q3
HRM 2015 Q3
HRM 2015 Q1
HRM 2015 Q1
HRM 2015 Q2
HRM 2015 Q2
HRM 2015 Q3
HRM 2015 Q3
CRM 2014 Q1
CRM 2013 Q1
CRM 2015 Q1
CRM 2015 Q1
CRM 2017 Q1
CRM 2017 Q1
CRM 2017 Q2
CRM 2017 Q2
CRM 2017 Q3
CRM 2017 Q3
In another sheet I have "Project " , " Start " "End"
I need to find the start and end quarter and fill in.
the out put should be "
HR 2014/Q1 2015/Q3
crm 2013/Q1 2017/Q3
ATTACHING A FILE-
in sheet- raw data - i need to search on ID- and in "Test.xlsxData" i need to fill in the start and the end date- as shown in Data sheet.
Bookmarks