looking for a function for recurrence of a number in excell

[Philippe]

For example, if 41 appears 1 or twice or 34 times in an array of number.
Thanks

 

[Bernard Liengme]

Have a look at COUNTIF
best

 

[Ashish Mathur]

Hi,

Look at pivot tables as well

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com