Hello. So right now I have Column G using this formula =SUMPRODUCT((G2:G232<>"")/COUNTIF(G2:G232,G2:G232&"")) which works great to getting the total number, regardless it has duplicates.. Example if Column G has A,B,B,C,D,D,D,E, the total values in that column are 5 as the B's and D's are counted as one.
Now my problem is I want to expand on this formula where it must be based on another column.. say Column H. Example column H has 1 next to A in column G, or 2 next to C in column G.. combing the two columns together will be something like this
A1, B1, B2, C2, D3, D1, D1, D4, E1
And I want to know how many values there are but related to column H. For example if we focus on 1, column G should return 3 only, 2 should return 1, 3 should return 1 and 4 should return 1.
I imagine I would need to add 'COUNTIF' or 'MATCH' to the formula I am currently using but this where I got stuck... tried playing around with it but still can't get what I am looking for..
Now my problem is I want to expand on this formula where it must be based on another column.. say Column H. Example column H has 1 next to A in column G, or 2 next to C in column G.. combing the two columns together will be something like this
A1, B1, B2, C2, D3, D1, D1, D4, E1
And I want to know how many values there are but related to column H. For example if we focus on 1, column G should return 3 only, 2 should return 1, 3 should return 1 and 4 should return 1.
I imagine I would need to add 'COUNTIF' or 'MATCH' to the formula I am currently using but this where I got stuck... tried playing around with it but still can't get what I am looking for..
