Need help in finding start and End Quarter

**eon13** · 08-19-2014, 12:03 AM

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.

**patel45** · 08-19-2014, 02:34 AM

desired output would be helpful

**HaHoBe** · 08-19-2014, 11:00 AM

Hi, eon13,

have you thought about using a Pivottable to solve your problem which would deliver all the information without any programming?

Ciao,
Holger