ExcelBanter - looking for a function for recurrence of a number in excell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - looking for a function for recurrence of a number in excell (https://www.excelbanter.com/excel-worksheet-functions/250275-looking-function-recurrence-number-excell.html)

Philippe

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

Bernard Liengme

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

Ashish Mathur[_2_]

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

All times are GMT +1. The time now is 05:28 AM.