VBA code to get highest hours value for all duplicate numbers, pls check below table

[ashish_RC]

NUMBER	NAME	HOURS	HIGHEST HOURS
9999	XXXX	23	54
6577	XXXX	43	66
6577	XXXX	66	66
9999	XXXX	22	54
6577	XXXX	53	66
6577	XXXX	23	66
9999	XXXX	54	54
6577	XXXX	65	66
9999	XXXX	22	54

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Welcome to the MrExcel board!

Do you really need a macro? Could you use one of these formulas, copied down?

Excel Workbook
	A	B	C	D	E
1	NUMBER	NAME	HOURS	HIGHEST HOURS
2	9999	XXXX	23	54	54
3	6577	XXXX	43	66	66
4	6577	XXXX	66	66	66
5	9999	XXXX	22	54	54
6	6577	XXXX	53	66	66
7	6577	XXXX	23	66	66
8	9999	XXXX	54	54	54
9	6577	XXXX	65	66	66
10	9999	XXXX	22	54	54
Highest Hours

 

[ashish_RC]

Welcome to the MrExcel board!

Do you really need a macro? Could you use one of these formulas, copied down?

Highest Hours

	A	B	C	D	E
1	NUMBER	NAME	HOURS	HIGHEST HOURS
2	9999	XXXX	23	54	54
3	6577	XXXX	43	66	66
4	6577	XXXX	66	66	66
5	9999	XXXX	22	54	54
6	6577	XXXX	53	66	66
7	6577	XXXX	23	66	66
8	9999	XXXX	54	54	54
9	6577	XXXX	65	66	66
10	9999	XXXX	22	54	54

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:57px;"><col style="width:65px;"><col style="width:127px;"><col style="width:43px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D2 =MAXIFS(C$2:C$10,A$2:A$10,A2) E2 =AGGREGATE(14,6,C$2:C$10/(A$2:A$10=A2),1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thank you Peter. This solution also helpful for me.

I need to calculate sum of hours where numbers are duplicate and paste the total result in TOTAL HOURS column.

Can I get below result using excel formula?

NUMBER	NAME	HOURS	TOTAL HOURS
9999	XXXX	5	20
6577	XXXX	10	50
6577	XXXX	10	50
9999	XXXX	5	20
6577	XXXX	10	50
6577	XXXX	10	50
9999	XXXX	5	20
6577	XXXX	10	50
9999	XXXX	5	20

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

Regards
Ashish

 

[Peter_SSs]

Can I get below result using excel formula?

Sure

=SUMIF(A$2:A$10,A2,C$2:C$10)

 

[ashish_RC]

this is really helpful for me, Thank you so much Peter.

 

[Peter_SSs]

this is really helpful for me, Thank you so much Peter.

You're welcome.