Need formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mrtvac - 10 May 2008 06:58 GMT

Hi,

Don't know does this forumula exists in Excel so I need help.

I need to count different values in range of cells.

Example:
I have cell ranges with this values: 13, 14, 15, 16, 13, 13, 16

I need formula which will return:
3 values of 13
1 value of 14
1 value od 15
2 values of 16.

Is this possible in Excel?

Thank you in advance.

Regards.

Signature

Pozdrav,
M

http://www.unreal-net.com/
Jedini web imenik na kojem mozete zaraditi!

http://forum.unreal-net.com/
Jedini forum koji dijeli zaradu sa clanovima!

Reply to this Message

Mike H - 10 May 2008 10:05 GMT

Maybe

=COUNTIF(A1:A50,13)
Mike

> Hi,
>
[quoted text clipped - 16 lines]
>
> Regards.

Reply to this Message

Gord Dibben - 10 May 2008 19:18 GMT

With the range of cells A1:A7 and the unique numbers 13, 14, 15 and 16 in B1:B4

Select C1:C4 and enter this formula in C1

=FREQUENCY(A1:A7,B1:B4) Note: this an array formula so you must enter it with
CTRL + SHIFT + ENTER.

Gord Dibben MS Excel MVP

>Hi,
>
[quoted text clipped - 16 lines]
>
>Regards.

Reply to this Message