| View previous topic :: View next topic |
| Author |
Message |
sevalav
OOo Enthusiast
Joined: 19 Sep 2009
Posts: 119
|
 Posted: Mon Nov 22, 2010 4:10 pm Post subject: FIND ANY TWO EQUAL CELLS, HOW? |
 |
|
Hello,
I need that macro can check column "A" are there any two cells with any equal content.
Any suggestion will be helpful. Thanks in advance. |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Nov 22, 2010 4:28 pm Post subject: |
|
|
This is a spreadsheet trivial. No macro needed.
B1 =COUNTIF($A$1:$A$999;$A1)
Copy down
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
sevalav
OOo Enthusiast
Joined: 19 Sep 2009
Posts: 119
|
| Posted: Tue Nov 23, 2010 3:48 pm Post subject: |
|
|
| I am sorry, but it must be a part of code. |
|
| Back to top |
|
|
|
