I have a huge sales spreadsheet, that I have used the Advanced filter to show me all of the unique part numbers that were sold. How do I count just those items to show how many unique items were sold.
Peace
MK
I have a huge sales spreadsheet, that I have used the Advanced filter to show me all of the unique part numbers that were sold. How do I count just those items to show how many unique items were sold.
Peace
MK
Last edited by VBA Noob; 02-13-2008 at 04:18 PM.
Hi,
Have you tried SUBTOTAL ?
=SUBTOTAL(2,A1:A20)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Use this array formula (must be confirmed with Ctrl+Shift+Enter instead of Enter): =SUM(1 / COUNTIF(A1:A100, A1:A100) )
Last edited by shg; 02-13-2008 at 04:49 PM.
SHG, That is really a great formula. I fooled around with a bunch o' "auto filter - unique - copy elsewhere" attempts on a worksheet I was using and got nowhere until I adapted your formula. I was trying to find individual names in a list 319 lines long (health insurance subscribers) which included all participants including spouse's and kids. Until I used your formula I got nowhere. I really apprecite your post, but doesn't it seem rediculous that Excel is so freakin' hard to use??? What is Microsoft's problem?? Sorry to rant a bit but every time I try to do anything other than the most simple tasks with Excel I hit a roadblock. At any rate, I truly appreciate your post. Thanks so much!
Sorry, misread your question, but here's an alternative
=SUMPRODUCT((1/COUNTIF(A1:A100,A1:A100)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks