Hello,
I am looking for some help with a way to create a formula that looks at three columns if there are duplicates that are common across all three columns to count them, but if there are no duplicates found I do not want a count. If possible I would like to do this for the entire column without dragging the formula down as there are over 10k rows. Below is an example and formula in Column E that I have now.
=COUNTIFS(B:B,B2,C:C,C2,D:D,D2)
<tbody>
</tbody>
This is what I am expecting as a result.
<tbody>
</tbody>
I am looking for some help with a way to create a formula that looks at three columns if there are duplicates that are common across all three columns to count them, but if there are no duplicates found I do not want a count. If possible I would like to do this for the entire column without dragging the formula down as there are over 10k rows. Below is an example and formula in Column E that I have now.
=COUNTIFS(B:B,B2,C:C,C2,D:D,D2)
A | B | C | D | E | |
1 | Column1 | Column2 | Column3 | Column4 | Count |
2 | asdf | PC208 | saw-fra | 1/1/2019 | 3 |
3 | asdf | PC255 | dfw-kkd | 1/5/2018 | 1 |
4 | aasdgd | PC011 | jgg-lwc | 7/5/2014 | 1 |
5 | asdfad | PC208 | saw-fra | 1/1/2019 | 3 |
6 | asdfad | PC777 | omt-lis | 7/14/2018 | 2 |
7 | asdf | PC208 | ohc-una | 1/1/2019 | 1 |
8 | asdfad | PC777 | omt-lis | 7/14/2018 | 2 |
9 | asdf | PC208 | saw-fra | 1/1/2019 | 3 |
<tbody>
</tbody>
This is what I am expecting as a result.
A | B | C | D | E | |
1 | Column1 | Column2 | Column3 | Column4 | Count |
2 | asdf | PC208 | saw-fra | 1/1/2019 | 3 |
3 | asdf | PC255 | dfw-kkd | 1/5/2018 | |
4 | aasdgd | PC011 | jgg-lwc | 7/5/2014 | |
5 | asdfad | PC208 | saw-fra | 1/1/2019 | 3 |
6 | asdfad | PC777 | omt-lis | 7/14/2018 | 2 |
7 | asdf | PC208 | ohc-una | 1/1/2019 | |
8 | asdfad | PC777 | omt-lis | 7/14/2018 | 2 |
9 | asdf | PC208 | saw-fra | 1/1/2019 | 3 |
<tbody>
</tbody>