Hello Dears
Please if anyone can support in that;
I need to convert the below formula to VBA code,
{=SUM(IF(("City"=Receiving[BRANCH])*('Build Dashboard'!I12=Receiving[CATEGORY LEVEL]), 1/COUNTIFS(Receiving[BRANCH],"City",Receiving[RECEIPT NUMBER],Receiving[RECEIPT NUMBER],Receiving[CATEGORY LEVEL],'Build Dashboard'!I12)), 0)}
The issue that I need a code to make a count for unique values depending on two different criteria, the count will be added in a table according to the input criteria
As per table below; the two criteria are (City & Category) and the unique count range is (Receipt no.).
Then, the data developed will be copied in the below table
Please if anyone can support in that;
I need to convert the below formula to VBA code,
{=SUM(IF(("City"=Receiving[BRANCH])*('Build Dashboard'!I12=Receiving[CATEGORY LEVEL]), 1/COUNTIFS(Receiving[BRANCH],"City",Receiving[RECEIPT NUMBER],Receiving[RECEIPT NUMBER],Receiving[CATEGORY LEVEL],'Build Dashboard'!I12)), 0)}
The issue that I need a code to make a count for unique values depending on two different criteria, the count will be added in a table according to the input criteria
As per table below; the two criteria are (City & Category) and the unique count range is (Receipt no.).
City | Category | Receipt no. | ||
X | XX | 222110130683 | ||
X | XX | 222110130683 | ||
Y | YX | 2310124850 | ||
Y | XX | 2110123413 | ||
X | XX | 2110123415 | ||
Y | YX | 2110123419 |
Then, the data developed will be copied in the below table
City | Category | Count |
X | XX | ?? |
Y | YX | ?? |