98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Duplicates
Duplicates
Resolved · Low Priority · Version 365
Geraint has attended:
Excel Advanced course
Duplicates
I have many duplicated rows of references but I just want to count a particular column from these. So in effect I have 30,000 rows but only 12,000 non-duplicated references and I want to find the Count of the values in a certain column. All values inside the specific column will be the same for each duplicated reference but I just cannot figure out how to quickly count them all to know how many non-duplicated references have X as the value or Y. Very annoying when I feel like it should be a very simple task, any advice would be superb!
RE: Duplicates
Hi Geraint,
Thank you for the forum question and for the nice feedback. I am happy that you found the course useful.
I hope, I fully understand what you want to do.
I have done some examples (please find attached Excel file). In the first table I have added conditional formatting to highlight duplicates and added a TOTAL ROW to the dynamic table (you can find this option under the TABLE DESIGN tab when you click inside the dynamic table) and changed the TOTAL row to COUNT. Then the table has been filtered BY COLOUR and the total row will show that there is 11 duplicates.
In the second below you can find Excel functions all highlighted in yellow.
I hope this can be helpful.
If you cannot find the attached file refresh your browser and if you still cannot see it below my reply, please wait 10 minutes and try again. Sometimes it takes some time after it is uploaded.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Fri 22 Dec 2023: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create a unique items table from a duplicating table1. Ensure that your list has column headings |