Thread
:
frequency above a certain number
View Single Post
#
1
Posted to microsoft.public.excel.misc
stevec
external usenet poster
Posts: 177
frequency above a certain number
A1:A10 are numbers
A2 is another number
A3 is a formula that states: the number of times A1:A10 is above A2
For example:
5 2 3 5 8 9 4 2 0 1 (numbers)
3
5 (# of times numbers are 3).
thanks...!
Reply With Quote
stevec
View Public Profile
Find all posts by stevec