Need formula help plzz

[murree]

Don't have rights to attach any file. I wanted to add the sample file so can explain better what formula I want to apply. I'll try copy/paste the contents and explain the scenario to see if this works.
In the following data, I need to see how many times a particular number from Column G "List" is with any other number starting with letter "J" in same Column G, with condition of having unique Acc# i.e. Column B.


[TABLE="width: 838"]
<tbody>[TR]
[TD]Sr#[/TD]
[TD]Acc#[/TD]
[TD]Name[/TD]
[TD]GAccNo[/TD]
[TD]DATE[/TD]
[TD]UserName[/TD]
[TD]List[/TD]
[TD]ECD Codes[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2,158[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/12/2015[/TD]
[TD]ADMN[/TD]
[TD]36591[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2,158[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/12/2015[/TD]
[TD]ADMN[/TD]
[TD]85025[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]2,158[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/12/2015[/TD]
[TD]ADMN[/TD]
[TD]96372[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]2,158[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/12/2015[/TD]
[TD]ADMN[/TD]
[TD]J1642[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]36591[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]85025[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]96365[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]96372[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]99213[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]J1642[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]J1756[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]2,505[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD]ADMN[/TD]
[TD]J7050[/TD]
[TD]2kj3k.0, 2837.2, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]36591[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]96365[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]96372[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]99211[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]J1642[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]J1756[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]2,506[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD]ADMN[/TD]
[TD]J7050[/TD]
[TD]2837.2, 2kj3k.0, 4.34, 8392.33,[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]36591[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]85025[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]96365[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]99213[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]J1642[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]J1756[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]2,512[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD]ADMN[/TD]
[TD]J7050[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD="align: right"]2,513[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]2/3/2015[/TD]
[TD]ADMN[/TD]
[TD]85025[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]2,513[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]2/3/2015[/TD]
[TD]ADMN[/TD]
[TD]99213[/TD]
[TD]2kj3k.0, 2837.2, 4.34,[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]2,514[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]2/17/2015[/TD]
[TD]ADMN[/TD]
[TD]36591[/TD]
[TD]2837.2, 2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]2,514[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]2/17/2015[/TD]
[TD]ADMN[/TD]
[TD]99212[/TD]
[TD]2837.2, 2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]2,514[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]2/17/2015[/TD]
[TD]ADMN[/TD]
[TD]J1642[/TD]
[TD]2837.2, 2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]36591[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]85025[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]96365[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]99213[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]36[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]J1642[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]37[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]J1756[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]2,688[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD]ADMN[/TD]
[TD]J7050[/TD]
[TD]2kj3k.0,[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]2,734[/TD]
[TD]JOHN, WRIGHT[/TD]
[TD="align: right"]99823[/TD]
[TD="align: right"]1/28/2015[/TD]
[TD]Taylor, Dorothy[/TD]
[TD]12345[/TD]
[TD]199.123,[/TD]
[/TR]
</tbody>[/TABLE]




Thanks,

EDIT
Following is the link to the same question posted on another forum. In case if its holding back to answer the question;

https://www.excelforum.com/excel-for...re-values.html