98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Count
Count
Resolved · Low Priority · Version 2007
Mon 7 Nov 2011, 15:55Delegate Sue said...
Sue has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Count
Count if the numbers are duplicates
Tue 8 Nov 2011, 14:11Trainer Simon said...
RE: Count
Hi Sue,
Thank you for your question and welcome to the forum.
The easiest way of doing it is to copy the figures into a range and then use the Remove Duplicates button on the Data Tab. This will remove the duplications and keep the unique values.
Underneath the new list use the count function to count the number of cells containing values.
I hope this make sense.
Regards
Simon
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:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |
