looking for a function for recurrence of a number in excell

Philippe · Dec 7, 2009

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

Bernard Liengme · Dec 7, 2009

Have a look at COUNTIF
best

Ashish Mathur · Dec 7, 2009

Hi,

Look at pivot tables as well

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com