Combine details on one sheet

[DorisEthel]

I have a sheet which hold job information and hours for several different employees for each month. Each job has its own code so for example there may be 10 separate entries that have job code A10. Is it possible to create a list on a separate page that automatically copies across the job codes from the master list and gives me a list of job codes. There can be several hundred entries but maybe only 15 different job codes. Doing it manually has meant job codes are missed

Thanks in advance

 

[Fluff]

Hi & welcome to MrExcel.
How about something like
=IFERROR(INDEX(Data!A$2:A$32,MATCH(0,INDEX(COUNTIF(A$1:A1,Data!A$2:A$32),0),0)),"")

 

[DorisEthel]

That didn’t work. Says there is missing information

 

[Fluff]

Did you change the sheet name & ranges to suit?
On the Data sheet

Excel 2013/2016
	A
1	Hole ID
2	2018PJAC001
3	2018PJAC001
4	2018PJAC001
5	2018PJAC001
6	2018PJAC001
7	2018PJAC002
8	2018PJAC002
9	2018PJAC002
10	2018PJAC002
11	2018PJAC002
12	2018PJAC003
13	2018PJAC003
14	2018PJAC003
15	2018PJAC003
16	2018PJAC003
17	2018PJAC003
18	2018PJAC003
19	2018PJAC003
20	2018PJAC004
21	2018PJAC004
22	2018PJAC004
23	2018PJAC005
24	2018PJAC005
25	2018PJAC005
Data

and on the other sheet

Excel 2013/2016
	A
1	ID
2	2018PJAC001
3	2018PJAC002
4	2018PJAC003
5	2018PJAC004
6	2018PJAC005
7
Sheet2

Cell Formulas
Range	Formula
A2	=IFERROR(INDEX(Data!A$2:A$32,MATCH(0,INDEX(COUNTIF(A$1:A1,Data!A$2:A$32),0),0)),"")