ExcelBanter - filtering data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filtering data (https://www.excelbanter.com/excel-discussion-misc-queries/162743-re-filtering-data.html)

Mike H

filtering data

Try,

=COUNTIF(A1:A100,"A")

The "A" could be a cell reference where that cell contains what you are
trying to count.

=COUNTIF(A1:A100,B1)

Mike

"Brie" wrote:

i want to filter and count the data in 1 column

4 eg. i have 3 different data, i.e. A, B and C.

Total A+B+C = 10 entries.

A=3 entries, B=4, C=4.

how to generate this data using formula or filter?

many thx.

brie

Brie

filtering data

wow, thx Mike! it works!

do you know if i can put "A=3" instead of just the total count?

brie

"Mike H" wrote:

Try,

=COUNTIF(A1:A100,"A")

The "A" could be a cell reference where that cell contains what you are
trying to count.

=COUNTIF(A1:A100,B1)

Mike

"Brie" wrote:

i want to filter and count the data in 1 column

4 eg. i have 3 different data, i.e. A, B and C.

Total A+B+C = 10 entries.

A=3 entries, B=4, C=4.

how to generate this data using formula or filter?

many thx.

brie

All times are GMT +1. The time now is 08:24 PM.