vba to count cells

[saravanan1981]

need vba for following task.

I have family id in column "E"
In column "J" I have details of their family members
I want to count of total family member including proposer against each proposer in column K
desired result mentioned on column k

Also please provide if any simple formula is available.

[FDibbins]

This regular formula will do the count for you...
=COUNTIF($E$2:$E$24,E2)

You could add in the text as needed

edit: this will add teh text and scip the repeated rows...
=IF(E2=E1,"","Total Family Member = "&COUNTIF($E$2:$E$24,E2))

[ikboy]

Please Login or Register  to view this content.

[saravanan1981]

HI, Thank you for the code. It works nicely. But the code calculates the id no from column “E”. Problem is that I have duplicate ID as well.

SO I want the formula to count Column “J” to count the number of cell starts from “PROPOSER” to the end of next “PROPOSER” and give result. Do not count next “Proposer” count before the next from one “Proposer” to before next “Proposer”


Please refer attachment from from row no.25. you can duplicate id as well (newly added)

[ikboy]

For formula : [k2]==IF(J2="PROPOSER",IFERROR(MATCH("PROPOSER",J3:$J$37,0),ROWS(J2:$J$37)),"")

By the way give you one more code:

Please Login or Register  to view this content.

[itty]

Dear ikboy,
I am new to VBA and trying to learning it by reading solved problems in the forum. Can u please explain the code u have written here for better understanding for a newbie? Especially d = CreateObject("scripting.dictionary"), UBound(arr), d(i),k = d.keys: t = d.items: j = UBound(arr) etc. These are new concepts to me. If at all my queries bothers your valuable time, please ignore
Regards,