Formula query

[horlicks]

I am trying to identify a formula which will add and then display th
number of times a number appears in a range.

For example, the range looks like this
.......A...........B............C
1...1110......1110.......1114
2...1110..... 1111.......1111
3...1111......1112.......1110
4...1111......1113.......1111

The numbers which appear in the applicable range e.g. 1110, could b
any number between 1110 and 9999 and as such I cannot simply predefin
which number to look for.

I am hoping the output could like as follows:

.......A........B
1....1110....4
2....1111....5
3....1112....1
4....1113....1
5....1114....1

Can this be done ? Did that make sense ?

Thanks in advance for any hel

 

[Kevin Stecyk]

horlicks wrote....

I am trying to identify a formula which will add and then display the
number of times a number appears in a range.

For example, the range looks like this
......A...........B............C
1...1110......1110.......1114
2...1110..... 1111.......1111
3...1111......1112.......1110
4...1111......1113.......1111

The numbers which appear in the applicable range e.g. 1110, could be
any number between 1110 and 9999 and as such I cannot simply predefine
which number to look for.

I am hoping the output could like as follows:

......A........B
1....1110....4
2....1111....5
3....1112....1
4....1113....1
5....1114....1

Can this be done ? Did that make sense ?

Thanks in advance for any help

horlicks,

One way, you might wish to investigate "histogram" on Tools | Data Analysis
menu. You might require to have the Addin Analysis Toolpack enabled.

I think you can specify your bins, and your input range.

Hope that helps.

Best regards,
Kevin

 

[Steven]

lookup the COUNTIF function im sure this will do what you need.

Regards,
Steve