| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a function for recurrence of a number in excell
For example, if 41 appears 1 or twice or 34 times in an array of number.
Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
looking for a function for recurrence of a number in excell
Have a look at COUNTIF
best -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP wishes "Philippe" wrote in message ... For example, if 41 appears 1 or twice or 34 times in an array of number. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
looking for a function for recurrence of a number in excell
Hi,
Look at pivot tables as well -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Philippe" wrote in message ... For example, if 41 appears 1 or twice or 34 times in an array of number. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a recurrence formula in Excel e.g. A(N+1)=A(N)+2 | New Users to Excel | |||
| recurrence | Excel Worksheet Functions | |||
| excell number formatting | Excel Worksheet Functions | |||
| how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
| How do I get excell to indicate when a number is out of a set ran. | Excel Worksheet Functions | |||
Hybrid Mode
