Frank Kabel Please Help !

G

guilbj2

Well, I'm appealing to anyone here but Mr. Kabel appears to be the go t
guy when tough questions come up...

I have a single column with a very long list of names. Each time
report is created at work, someone gets is assigned to them (there ar
around 200 employees). I'm trying to figure out how many reports hav
been assigned to each person (around 1000 reports have been assigned t
date). Essentially, I need to find a way to check the all of the name
in the column and output a list of the names and how many times each o
them appear. I'm struggling to figure this one out, thanks very muc
for anyone who takes the time to respond
 
J

JudithJubilee

One way it to do a Subtotal. You need to sort the list
and choose Data + Subtotal. Choose At each change in
Name and OK.

Hope this helps
Judith
 
L

Lady Layla

Actually not a tough question at all. Try using Pivot Table

: Well, I'm appealing to anyone here but Mr. Kabel appears to be the go to
: guy when tough questions come up...
:
: I have a single column with a very long list of names. Each time a
: report is created at work, someone gets is assigned to them (there are
: around 200 employees). I'm trying to figure out how many reports have
: been assigned to each person (around 1000 reports have been assigned to
: date). Essentially, I need to find a way to check the all of the names
: in the column and output a list of the names and how many times each of
: them appear. I'm struggling to figure this one out, thanks very much
: for anyone who takes the time to respond.
:
:
: ---
:
:
 
C

Charlie

A countif might be in order.

If there is room on the current sheet add a column listing
all the (200) Employee's. Let's say Column G starting
with row 3 (G3). And assuming the Employee's being
assigned work have their names in column A.

In Column H3 enter =COUNTIF($A:$A,G3)and copy down to the
last employee name (H203).

Charlie O'Neill
 
B

Bob Phillips

and may I say that the opening statement is probably offensive to many
contributors in these groups who have proved themselves the most innovative
Excel minds (bar none, not even in MS) over many many years. I am referring
to Chip Pearson, Tom Ogilvy, Dave Peterson, Stephen Bullen, Rob Bovey, John
Green, Aladin Akyurek, Jim Rech, Harald Satff, Jon Peltier, Harlan Grove,
and many more (apologies to the many omissions that I have made). These guys
have provided answers, information, and assistance of the highest order, to
far tougher questions than you asked.

It is not a good idea, even unwittingly, to reduce your potential support
group.

Bob
 
F

Frank Kabel

Hi Bob
totally agree with your comment. wish for example I had the knowledge
of Harlan in respect to really tough worksheet functions

for the OP: Please don't restrict your answers as the person you are
aksing for might be not availbale (as I have been) :)
 
Top