| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What is the correct function to use, please?
I need to get the number of times each of these appear.
77777 77777 77778 77778 77778 77779 So for 77777 I would want it to display 2, and for 77778 I would want to get a 3, for 77779 a 1, and etc. Unfortunately the list of zip codes is several thousand long so I cannot do a COUNT function for each individual zip code (I want excel to do it all for me). Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| pmt function in Excel does not return correct monthly payment amou | Excel Worksheet Functions | |||
Threaded Mode
