| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count the number of times the same number shown
We have a list of numbers (which can vary) in a row that can have the some
number multiple times. I would like to count the number of times each number is shown. Can someone suggest an easy way of doing this. Thanks Noemi |
|
#2
|
|||
|
|||
|
Lets say your data is in Row1 starting in cell A1. In cell A2 enter the
formula =COUNTIF(1:1,A1) and copy it accross. This will give you a count for each number. Alternately if your data is in a column eg Column A, in cell B2 place the formula =COUNTIF(A:A,A1) and copy it down. Again this will give you a count for each number. Hope this helps Rowan Noemi wrote: We have a list of numbers (which can vary) in a row that can have the some number multiple times. I would like to count the number of times each number is shown. Can someone suggest an easy way of doing this. Thanks Noemi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
| Count the number of worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
