Need formula for Unique Distributor Count

[Basavaraj K H]

Dear Team

I Need formula for Unique Distributor Count,

Kindly refer attached file,
already I put the unique Distributor count in Column C > Sheet Pivot,
required same in formula.

Thanks advance

Regards
Basavaraj K H

 

[NARAYANK991]

Hi Basavaraj ,

See if this is OK.

Narayan

 

[Somendra Misra]

Hi Basavaraj,

Try below formula in C4 and copy down:

=SUM((IF(FREQUENCY(IF((A4='Master Sheet'!$B$2:$B$605)+(A4='Master Sheet'!$C$2:$C$605),MATCH('Master Sheet'!$G$2:$G$605,'Master Sheet'!$G$2:$G$605,0)),IF((A4='Master Sheet'!$B$2:$B$605)+(A4='Master Sheet'!$C$2:$C$605),MATCH('Master Sheet'!$G$2:$G$605,'Master Sheet'!$G$2:$G$605,0))),1,0)))

Confirm with Ctrl+Shift+Enter. Note in some cells you have not given the correct result.

Regards,

 

[srinidhi]

If you data is soughed, then the formula in the attached sheet will help. The Distributor Name's names are not consistent across the sheet, hence there is a discrepancy with the number you have typed & with the formula I have. Please change the names to a single spelling then the formula will work.

 

[Basavaraj K H]

Yes Madam there difference in the dist name, but is it possible to take from dist number, pls

 

[srinidhi]

The dist number ids are different for the same name.

9964838580 Shri Channabasaveshwara
7026785255 Shri Channabasaveshwara
7353822406 Sri Chowdeshwari Enterprises
8970885770 Sri Chowdeshwari Enterprises