# Count to match three column text

0

I have an excel list as shown below – I wanted to count the occurrence matching THREE Columns:

A                                              B             C

Practical

2/9/2019

Shift A

Practical

2/9/2019

Shift A

Practical

2/9/2019

Shift A

Practical

2/9/2019

Shift A

Practical

2/9/2019

Shift B

Practical

2/9/2019

Shift B

Practical

2/9/2019

Shift B

Theoretical

1/6/2019

Shift B

Theoretical

1/6/2019

Shift B

Theoretical

1/6/2019

Shift B

Theoretical

1/6/2019

Shift B

Theoretical

1/6/2019

Shift C

Theoretical

1/6/2019

Shift C

Theoretical

1/6/2019

Shift C

Theoretical

1/6/2019

Shift B

Theoretical

1/6/2019

Shift B

Theoretical

1/6/2019

Shift B

Practical

1/9/2019

Shift A

Practical

1/9/2019

Shift A

Practical

1/9/2019

Shift A

Practical

1/9/2019

Shift B

Practical

1/9/2019

Shift B

Need a formula to count How many "practical"  for  the particular "date"   "shift A" .

Answer should be è       On 2/9/2019  Shift A , Practical  =  4

On 2/9/2019 Shift B, Practical  = 3

On 1/9/2019 Shift A, Practical = 3 and so on

0

I copied your sample data to the range A32:C53. Then I entered the formula below in D32 and copied down.

``=COUNTIFS(\$A\$32:\$A\$53,\$A32, \$B\$32:\$B\$53,\$B32, \$C\$32:\$C\$53,\$C32)``

You can then create a list of unique values by ...

1. copy column D to the clipboard and Paste Special > Values
(to replace the formulas with their results).
2. select Remove Duplicates from the Data tab, defining duplicates by all columns in range A32:D53