Question description:
This user has given permission to use the problem statement for this
blog.
I am looking to create a formula that will count the number of unique values with particular parameters. For example:
Lays Original Process A204
Lays Original Packaged A204
Lays Original Process A206
Lays BBQ Process A403
Lays Original Packaged A206
I would like to count how many Lays Original Packaged Code. The result from this list should be 2 (A204 and A206).
Solved by Z. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/04/2018 - 04:45
HI
Excelchat Expert
24/04/2018 - 04:46
Welcome to Got It Pro
User
24/04/2018 - 04:46
hello
Excelchat Expert
24/04/2018 - 04:46
Can you copy the information into the preview.
User
24/04/2018 - 04:46
the information i sent in the question?
Excelchat Expert
24/04/2018 - 04:46
Yes. Please.
Excelchat Expert
24/04/2018 - 04:51
i have used countifs formula.
Excelchat Expert
24/04/2018 - 04:51
=countifs(A:A,A2,B:B,B2,C:C,C2)
User
24/04/2018 - 04:51
but the response should be in a table like this (see G)
Excelchat Expert
24/04/2018 - 04:53
Please refer to the Pivot table1
Excelchat Expert
24/04/2018 - 04:54
I have provided unique items.
Excelchat Expert
24/04/2018 - 04:57
Hi
Excelchat Expert
24/04/2018 - 04:57
Hope, it is reviewed.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
