How to Copy without repetitions or find repetitions?

[pawel.lang]

I have a column with a plenty of repeated names.

What I need is to list those names (without repetitions) and then to count how often they do occure in the list.

Any sugestion? I'm in desperate hour...

[Dale]

QUICK AND DIRTY:-

Say your list is in B2:B13

In col D "=COUNTIF($B$2:$B2;B2)" (without quotes) and drag to bottom of list gives you the number of times the name has occurred so far in the list.

In Col C "=COUNTIF($B$2:$B$14;B2)" (and drag) gives you the total number of times the name occurs in the list.

Select your list, including cols C & D and headings.
Data menu, click Auto Filter
Select "1" from tdhe drop down list in col D (this appears at the heading when you click Auto Filter).

You should now have a list of names (appearing once only) and how often they appear (before applying the filter). Select the appropriate columns.
Copy
Paste Special (uncheck everything except "String" and "Number")

This should give you the list you want.
Note: because you have not posted the formulas, the list will be static. You should maintain the original list and repeat this exercise when you need to generate the report again. (Right off the top of my head I can't think of an easy way to come up with a dynamic list that doesn't contain zero-length strings where the repeated names would be.)

Hope this helps.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos

[Dale]

I just read my reply. It's real easy to miss the "$" signs in the COUNTIF formulas. What I've written is correct (I think), but pay attention!
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos

[pawel.lang]

Great! THX!

However it doesn't count the names.

Its not relevant by now 'couse I can handle it by myself. Once more thx!