Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
88
Views
Topic starter
Hi Everyone.
I need some help. The attached picture shows a set up in a spreadsheet.
i want to count the duplicates in the bottom cell.
Im sure this should be easy but i cant see how to do it?
just to clarify in the picture the number of duplicates would be 4.
Posted : 15/07/2024 11:46 am
Hi Andrew,
Nothing attached. Can you please supply a file rather than a picture? Saves us having to recreate your data.
regards
Phil
Posted : 15/07/2024 5:44 pm
Topic starter
Hi Phil,
My apologies. File is attached.
Thanks
Andrew
Posted : 16/07/2024 5:59 am
Hello,
You can use =SUM(COUNTIF(A1:A17,B1:B17)) to sum the duplicates found in column B.
Br,
Anders
Posted : 17/07/2024 11:06 am