| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display and count the number of times a value appears
I suppose that you have zip codes in col A (A1:A100). enter manually zip codes in col B only once as you shown in your question then in col C enter following formula. =COUNTIF($A$1:$A$100,B1) and copy it down in col C untill your data in col B ends. hope this will solve your problem. dbath Wrote: I am trying to count the number of times each zip code appears in an address list and have it display each zip code with the count beside it ie 11456 6 20457 5 74653 12 -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=554687 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
| how do i count text and display it as text plus the # times it hap | New Users to Excel | |||
| count and display unique values | Excel Worksheet Functions | |||
| How can the count of filtered records always display? | Excel Worksheet Functions | |||
| Display count of rows | Excel Worksheet Functions | |||
Threaded Mode
