count the duplicate values

Do you mean you want to sum the values for 7151.035 (Blanking plate) and EPKS SRVR (R710), which are marked as "Fix"?

If so you can use the formula =SUMIF(C2:C11,"fix",E2:E11)

A SUMIF or COUNTIF function will only count or sum matching values. Doing the same thing in a loop inside a macro would be much slower. Is there a reason it needs to be done in a macro?

yES I HAVE TO PRGRAM SOMETHING IT IS JUST ONE CHUNK OF iT.

I'm still not sure exactly what you're trying to do, but if you really want to do it programmatically you could try:

Please Login or Register  to view this content.

In coloumn A there are entities that are repeated,
In coloumn D there are Unique values,
I want to count the No. of Times these Unique values present in coloumn A
With the condition that colomn C should have fix in the respective Row.
Whichever unique value has fix in coloumn C we Have to count that(duplicate values in coloumn A).

How about this ... I've modified the code in your attachment to:

Please Login or Register  to view this content.

That should do the job.

Thanks.
I was just trying that thing but i dont know there was some conflict between for and if anyways.
You made it look easier , So Thanks!