View Full Version : Counting number of times a username appears in column A


Listerman
03-05-2008, 08:54 AM
I have a spreadsheet and the only column that matters is D.

Down column D it appears as:
a
b
b
b
c
c
d
e
f
c
a

I need the result to just appear like
A - 2
B - 3
C - 3
D - 1
E - 1
F - 1

gemma-the-husky
03-05-2008, 09:33 AM
look at "totals" query - you need the count function

click the sigma icon in the query design pane

Listerman
03-05-2008, 10:23 AM
I figured it out. Just used a Simple Amount: SUM(IIf([Name]=[Name],1,0)