Formula query

  • Thread starter Thread starter horlicks
  • Start date Start date
H

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
 
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
Click to expand...

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
 
Back
Top