Counting in a range

  • Thread starter Thread starter serge
  • Start date Start date
S

serge

Hi,

I would like to count how many times a new value is entered in a
range.

For exemple:
I have a range of numbers (A1:A100). If I put in a number in A101, I
would like to check via a button who many times that number is already
in de range.
 
don't need code for this, just use the COUNTIF()
worksheet function


Patrick Molloy
Microsoft Excel MVP
 
Thank you for the answer.

But I would like to use a button so i think i need VBA for that
button.
Everytime a new value is entered, the button should count how many time
the new value is entered.

Serge
 
Back
Top