| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort and create a Table of one column of dates
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort and create a Table of one column of dates
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| How do I sort a column of dates by the month? | Excel Discussion (Misc queries) | |||
| Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
| How do I sort a horizontal worksheet to create a vertical table | Excel Worksheet Functions | |||
| Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
Linear Mode
