|
Posted to microsoft.public.excel.programming
|
|
|
Sort and create a Table of one column of dates
Thanks a lot!!
"Gary''s Student" wrote:
Use a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
You set it up as Count of customers by customer
--
Gary''s Student - gsnu200849
"velu" wrote:
I have only one column of dates that runs to 10000 cells. Each cell has a
company name that ranges to 3000 different names.
Is there a way to create a table (next to the first column of data) which
list the company name with reference to number of times its present?
Like.
ABCD Company
TOM company
Asdf company
Xyz company
TOM company
TOM company
TOM company
TOM company
Xyz company
Xyz company
Xyz company
Xyz company
Xyz company
Asdf company
Asdf company
Asdf company
ABCD Company
The result I need is
ABCD Company 2 times
TOM company 5 times
Asdf company 4 times
Xyz company 6 times
Please help..
PS. I am using Excel 2007
|