-
CountIF
I have a column of id numbers, there are more than one id number and I need to know how many there are of the same ones without using sort by ascending. There could be 100 of the same id number and I just want the first one to show how many there are. I was shown this before, but do not remember, can anyone help please?
-
Howdy. Depending on your circumstances, you could use Advanced Filter, Unique values, either in place or to another location.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
-
How do you want indexes and number of each displayed?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules