DCOUNT Help

L

Luke

I am trying to use the dcount function to count how many
of each zip code I have in a mailing list. I am losing my
mind (short trip)
 
A

Aladin Akyurek

Try either to build a pivot table from your zip code data or to invoke a
CountIf formula after extracting a unique list of zip codes using Advanced
Filter.

If you insist on using a D-function, you'll need a unique list of zip codes
along with 'data table method'.

See http://makeashorterlink.com/?V55122CD5 which also describes other
methods involving D-functions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount -Date Criteria - Won´t find it - 0
Using DCOUNT 3
DCOUNT Help 2
need help on either doing a loop and counting specific values orusing subtotal function 2
DCOUNT or nested functions? 2
Repeated phrases wildcard? 1
Insert name and adress from a list in a word document 1
Functions 2

Top