Calculation/functionality for frequency of rows with specific text

G

Guest

Hi All,

Once again, stumped by Excel. Gotta say--it's times like this where I miss
a true query language.

So, here's my problem: I have a raw Excel sheet (converted from CSV) with
about 1k rows of data--an extraction of customer support cases, with each row
a unique case, showing typical values--d/t opened, closed, case #, customer,
case type, problem type... I need to generate a table from this which
contains the Top X case submitters based on customer name (and inevitably
sorted by various other factors). I know Frequency might work if I was
dealing with #'s, but I can't seem to wrap myself around the calculation.
Even if Frequency DID work for textual values, I have somewhere on the order
of several hundred customer names which would have to represent the
"ranges"... which would defeat the purpose of automating this. I need to A)
Count frequency of each customer and if possible, B) Show either a "Top
Ten" list of offenders, or a "Show All Customers In Excess of 5".

Any takers? (Yes, I know, it's like trying to squeeze milk from a rock...
but sometimes, you've just got an urge to pull on a quartz udder.)

Thanks,

Jamie
 

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

Returning the first 4 rows of a table 1
countif for only visible rows when combined with autofilter - possible? 1
Count unique values for rows meeting specific criteria? 4
sum and do calculation at each change for 900000 rows 1
Sum visible rows with text and numbers 1
How do I select a specific amount of random values for individuals 2
how to change For i - to refer to specific columns instead of rows 6
How to restrict the TitleRow only for a specific range of rows? 1

Top