quickie

[Joe_Fox]

Hello,

A quick excel question:

If I have column A1 full of date like this:

A1

Sarah
Sarah
Sarah
Jack
Jack
Jack
Jack
Dave
Dave

...what is the formula to count recurrences of each name. I want the answers to come out as Sarah = 3, Jack = 4, Dave = 2.

I can do it in Access but is there a way of doing it in excel?

Thanks,
Joe

 

[Dour]

Cataloguing your porn?

 

[Joe_Fox]

Cataloguing your porn?

:icon_lol:
No, just want to group all recurrences of names and count how many instances of each there are.

 

[Macky]

wrong forum joe, try Tech

 

[Steven]

Hello,

A quick excel question:

If I have column A1 full of date like this:

A1

Sarah
Sarah
Sarah
Jack
Jack
Jack
Jack
Dave
Dave

...what is the formula to count recurrences of each name. I want the answers to come out as Sarah = 3, Jack = 4, Dave = 2.

I can do it in Access but is there a way of doing it in excel?

Thanks,
Joe

Alt-->Data-->Subtotals

 

[Joe_Fox]

Alt-->Data-->Subtotals

Thanks Steve,

Also, If I had a spreadsheet with solely names in it, no column headers, just names and blank cells like this:

   A1    A2    A3
1  Joe  Bob
2       Joe    Paul
3  Liz         Liz

...is there a way of producing a list of just the names all in one column and getting rid of the blanks?

So this list would produce:

   A1
1  Joe
2  Bob
3  Paul
4  Liz

If you can help it'd be great.

 

[Joe_Fox]

Is that a no?

 

[Scarby]

i think so Joe!

isnt it in 'help'?

 

[Steven]

Is that a no?

I know of no way.

 

[mitcho_uk]

The only way i can think to do it is to sort each column so that the blanks will be at the bottom and then cut and paste them into one column. Not exactly what you want but its one way of doing it