| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting the number of same value cells
Hi,
I have rather large list of customer addresses and I want to know how many are in each state. Then I would like to take that information and paste it on another sheet. What function I would I use to that. Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting the number of same value cells
Depends on you data layout, certainly, but if your addresses are in rows
and the states are in their own column, strongly consider a Pivot Table: http://peltiertech.com/Excel/Pivots/pivotstart.htm In article , Richard wrote: Hi, I have rather large list of customer addresses and I want to know how many are in each state. Then I would like to take that information and paste it on another sheet. What function I would I use to that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of cells that make up a sum.. | Excel Discussion (Misc queries) | |||
| Formula for counting number of cells | Excel Discussion (Misc queries) | |||
| Counting the number of cells within a certain hour. | Excel Discussion (Misc queries) | |||
| Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
| cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
Hybrid Mode
