ExcelBanter - Excel

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel (https://www.excelbanter.com/excel-programming/370948-excel.html)

duse

Excel

In A1:A40 I enter numbers from 1 to 6. whats the formula to see how many
times a specific number is entered?
--
Fabio

Mike Middleton

Excel

Fabio -

COUNTIF function or array-entered FREQUENCY function or Analysis ToolPak
Histogram tool.

- Mike
http://www.mikemiddleton.com

"duse" wrote in message
...
In A1:A40 I enter numbers from 1 to 6. what's the formula to see how many
times a specific number is entered?
--
Fabio

All times are GMT +1. The time now is 06:22 AM.