I'll probably need an array for this one:
Column A has a list of product numbers. What's the right formula (Ctrl+Shft+Etr?) for finding out how many times each one in the list appears there?
I'll probably need an array for this one:
Column A has a list of product numbers. What's the right formula (Ctrl+Shft+Etr?) for finding out how many times each one in the list appears there?
=countif($a$2:$a$13,a2)
Drag down
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Please see attached file with formulas for unique list and count
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks. Both column E and F are arrays, aren't they?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks