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.


---
Message posted from http://www.ExcelForum.com/

don't need code for this, just use the COUNTIF()
worksheet function


Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
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.


---
Message posted from http://www.ExcelForum.com/

.

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


---
Message posted from http://www.ExcelForum.com/