I need an excel genius' help

[nickerjones]

I need to be able to take a large list of names, that I continuously add too, and count how many times they occur.

In context this a ranking system to see how many time each persons comes to an event.

Is something like this possible?

[PowerPlayoffs06]

This help at all?

http://www.extendoffice.com/document...in-column.html

[Komskies]

=countif sounds like the formula you want.

[Boblobla]

I did something similar using =countif. How many different names are you going to have?

[Leon]

Do you know the names that you want to count? If so:

[para transit fellow]

pivot table

[nickerjones]

I don't know the names... I want every name to be listed that has been to an event and how many times they have been.

[wireframe]

Use a pivot table. This tutorial looks decent: http://www.excel-easy.com/data-analy...ot-tables.html

[DoubleK]

+1 for pivot table.

Google is your friend for Excel help. No matter what you want to do, someone has already figured it out.

[nickerjones]

Originally Posted by DoubleK

+1 for pivot table.

Google is your friend for Excel help. No matter what you want to do, someone has already figured it out.

I googled it the problem is, it's hard to explain what I want to do to google. I saw the countif tutorials but that's not what I needed.

[psyang]

Sometimes pictures are worth 1000 words. Here's what I did:

1) Created an Excel spreadsheet with one column holding a bunch of rows with a, b, c, and d randomly distributed.
2) Inserted a pivot table
2a) Selected the column with my a-d values as the range to pivot
2b) Added the pivot table to the existing worksheet

Spoiler!

3) A window opens to the right with Pivot Table options. Dragged the "a" (representing my values) from the "Choose Fields" window to the "Column Labels" and the "Sum Values" window.

Spoiler!

Once I did this, the pivot table updated to show the counts

Spoiler!

Hope this helps!

[DoubleK]

Part of the challenge is you are using a spreadsheet for something that should be done in a database

[scotty2hotty]

Just pay someone five bucks to do it for you and save yourself X hours of pulling your hair out.


www.fiverr.com

[nickerjones]

Originally Posted by scotty2hotty

Just pay someone five bucks to do it for you and save yourself X hours of pulling your hair out.


www.fiverr.com

Thats the best idea ever!!! I really didn't even think of fiverr. I guess the problem is I will continually be adding to the list ( about once a month with another list of 80-150 names)

[Wormius]

The pivot table is your friend. Psyang has all the steps there;I think this highlights the end results a wee bit better.

[nickerjones]

Thanks guys,

I paid a guy 5 bucks to make a pivot table. I finally figured it out before he sent it to me. Once I get like in your picture, is there anyway to sort it so the count goes from largest to smallest? i.e. the person who has been to 10 events at the top vs the person going to 1 is at the bottom?

[Wormius]

Originally Posted by nickerjones

Thanks guys,

I paid a guy 5 bucks to make a pivot table. I finally figured it out before he sent it to me. Once I get like in your picture, is there anyway to sort it so the count goes from largest to smallest? i.e. the person who has been to 10 events at the top vs the person going to 1 is at the bottom?

Yep. Right-click one of the cells under "Count of people". You should see "Sort" as one of the options. Just select "From Largest to Smallest" from there.

Mind you this is my old copy of 2007. Things may appear slightly differently.