Combine details on one sheet

DorisEthel

New Member
Joined
Sep 16, 2018
Messages
2
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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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)),"")
 
Upvote 0
Did you change the sheet name & ranges to suit?
On the Data sheet


Excel 2013/2016
A
1Hole ID
22018PJAC001
32018PJAC001
42018PJAC001
52018PJAC001
62018PJAC001
72018PJAC002
82018PJAC002
92018PJAC002
102018PJAC002
112018PJAC002
122018PJAC003
132018PJAC003
142018PJAC003
152018PJAC003
162018PJAC003
172018PJAC003
182018PJAC003
192018PJAC003
202018PJAC004
212018PJAC004
222018PJAC004
232018PJAC005
242018PJAC005
252018PJAC005
Data


and on the other sheet


Excel 2013/2016
A
1ID
22018PJAC001
32018PJAC002
42018PJAC003
52018PJAC004
62018PJAC005
7
Sheet2
Cell Formulas
RangeFormula
A2=IFERROR(INDEX(Data!A$2:A$32,MATCH(0,INDEX(COUNTIF(A$1:A1,Data!A$2:A$32),0),0)),"")
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top