Remove duplicate data from Excel sheet

[Cyndi2210]

The excel sheet has multiple lines for the hours, however I need the sum of regular & overtime hours to show only in the top row for each person. Each person could have 1 to 4 lines. The data is contained within a query.

 

[dreid1011]

Is the hours column also a result from the query? I suppose that doesn't really matter, you can just fill that column with the below formula after the query is run to get the result as below:

Book1 1-18-2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Last Name	First Name	SSN	Hours	Earning	Type	401K	401L	401L2	Roth	Gross Earnings	Regular Hours	Overtime Hours
2	Smith	John		40								40	0
3	Smith	John										40	0
4	Smith	Sally		50.41								40	10.41
5	Kerns	Marc		40								40	0
6	Kerns	Marc										40	0
7	Brown	Robert		47.5								40	7.5
8	Brown	Robert										40	7.5
9	Brown	Robert										40	7.5
10	Cameron	Joshua		40								40	0
11	Cameron	Joshua										40	0
12	Carter	Amanda		49.24								40	9.24
13	Castle	Mollie		50.32								40	10.32
14	Castle	Mollie										40	10.32
15	Bates	Richard		69.16								40	29.16
16	Bates	Richard										40	29.16
17	Bates	Richard										40	29.16
18	Bates	Richard										40	29.16
Sheet7

Cell Formulas
Range	Formula
D2:D18	D2	=IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)=1,SUM(L2:M2),"")

 

[Cyndi2210]

Thanks. That worked perfectly.

 

[dreid1011]

Thanks. That worked perfectly.

You're welcome, and happy to help.