| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Have column of nums, need qty of each?
I have a column of a couple of thousands of numbers and I need a quick easy way to figure the qty of each number in the column. Is there an easy way to do this in Excel? Thanks, Scot -- samckitt ------------------------------------------------------------------------ samckitt's Profile: http://www.excelforum.com/member.php...o&userid=33089 View this thread: http://www.excelforum.com/showthread...hreadid=528989 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Have column of nums, need qty of each?
=COUNTIF(A1:A15,B1) this works for a specific range =COUNTIF(A:A,B1) this is for a specific column Place this formula in B2 B1 you will enter the number you want counted -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=528989 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Have column of nums, need qty of each?
If you know the number you are looking for (e.g., 2146), you can use
something like: =COUNTIF(A:A,2146) If you want the frequency of occurrence of all unique numbers (without knowing in advance what they are), you will probably need some code. "samckitt" wrote in message ... I have a column of a couple of thousands of numbers and I need a quick easy way to figure the qty of each number in the column. Is there an easy way to do this in Excel? Thanks, Scot -- samckitt ------------------------------------------------------------------------ samckitt's Profile: http://www.excelforum.com/member.php...o&userid=33089 View this thread: http://www.excelforum.com/showthread...hreadid=528989 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Have column of nums, need qty of each?
Hi
Create a pivot table based on column (as field in pivot table). In pivot layout sheet, set row=field, and data=(count of field ). Its all. Arvi Laanemets "samckitt" wrote in message ... I have a column of a couple of thousands of numbers and I need a quick easy way to figure the qty of each number in the column. Is there an easy way to do this in Excel? Thanks, Scot -- samckitt ------------------------------------------------------------------------ samckitt's Profile: http://www.excelforum.com/member.php...o&userid=33089 View this thread: http://www.excelforum.com/showthread...hreadid=528989 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
