Formula query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

horlicks - 14 Apr 2004 18:00 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Kevin Stecyk - 14 Apr 2004 18:15 GMT

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.
[quoted text clipped - 22 lines]
>
> 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

> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Steven - 14 Apr 2004 18:41 GMT

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

Regards,
Steve

> I am trying to identify a formula which will add and then display the
> number of times a number appears in a range.
[quoted text clipped - 25 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message