Excel 2000 – Sorting Long Lists

[kevsim]

I am using Excel 2000 and have varying lists in one column with from 100 to about 800 items. I wish to know how many times the same items appear on each list.
I want to know the item name and then the number of times it appears.
I would appreciate some advise on how to write the Query in VB code.
kevsim

 

[al_b_cnu]

Hi,

How about

Book1
	A	B	C	D
1	Heading		Heading
2	a		a	3
3	b		b	2
4	c		c	2
5	d		d	1
6	e		e	1
7	f		f	1
8	a		g	1
9	a
10	b
11	c
12	g
Sheet1

The list in column C was created by Data|filter|Advanced Filter and 'Copy to another location' & 'Unique records only'

The formula in column D2 (& copied down) is =COUNTIF(A:A,C2)

HTH

Alan

 

[MartinK]

For the list of uniques, see here, couple of threads far:
(no VBA needed, IMO)

http://www.mrexcel.com/board2/viewtopic.php?t=77164

Martin

 

[kevsim]

al_b_cnu, Thanks for the info, works great.
kevsim