Got Dups in Excel?
Say you have a list of invoices in Column A, and you need to know how many times an invoice is listed.
In column B, use the Count formula....
=COUNT(A1,A1:A8)
The first parameter says which cell to count, and the second parameter delineates the range.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment