Counting distinct values in excel - frequency function yes I have read Counting distinct values in excel - frequency function

I am trying to count a column with different numbers:

The column contains (search)

```1 3 7 9 5 1 3 9 4
```

Expected result:

```C1  C2
1 = 2
2 = 0
3 = 2
4 = 1
etc```
Oct 20, 2022 in Others 321 views

## 1 answer to this question.

You can use COUNTIF to count the number of elements that match a condition.
Suppose you have your numbers in column A, say from A1 to A10:

```A1: 1
A2: 3
A3: 7
```

etc...
Type in somewhere on your sheet, say in column B, the values you are interested in:

```B1: 0
B2: 1
```

etc...
and in C1, type in
=COUNTIF(\$A\$1:\$A\$10, B1)

This should count the number of values equal to B1 (i.e. 0), in A1:A10.

• 63,700 points

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

## How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

## IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

## Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

## Convert image (jpg, png, jpeg) to base64

Try this - it will perform the ...READ MORE

## How to return a result from a VBA function

You must associate the value with the ...READ MORE

## Help needed with Median If in Excel

Try entering the formula =MEDIAN(IF(\$A\$1:\$A\$6="Airline",\$B\$1:\$B\$6,"")) in another ...READ MORE