-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
triplicates
-
V
COUNTIF not working for highlighting Triplicates
Hello, I am using this formula to highlight triplicates or greater: =COUNTIF($A$2:$A$16,A2)>3 However it is not working as intended and this is the result I am getting: https://pasteboard.co/I5fZ0Nt.png- VBAExcellNoob
- Thread
- countif intended result triplicates working
- Replies: 6
- Forum: Excel Questions
-
H
Register a value when TRIPLICATE MATCH found
How to register a number 1 in the row/(s) when ‘triplicate match’ are found? Thanks for the help in advance. I am using Excel2007 <tbody> B C D 2 Peter 3 James 4 Peter 5 Jack 6 Jack 7 Peter 1 8 Jack 1 9 Jack </tbody>- hsandeep
- Thread
- triplicates
- Replies: 3
- Forum: Excel Questions
-
L
Identifying Reoccurring Account Numbers
I have 5 columns of account numbers, I need to identify account numbers that: 1. Appear in column 1 AND 2. Appear in at least 3 of the other 4 columns Anyone know how to identify the account numbers that fit that criteria? Thanks!- laxd17
- Thread
- account numbers conditional formatting duplicates reoccurring triplicates
- Replies: 5
- Forum: Excel Questions
-
J
Conditional Formatting Wont Work
Hi guys, all I want is to set up a format where if the value has a triplicate or more it would highlight. Seems simple enough and this was my formula, =countif($K$5:$K$30,$K5)>=$M$3 where M3 is 3. Or i tried =countif($K$5:$K$30,$K5)>=3 but neither seems to work correctly. Could someone let...- jaxisdex
- Thread
- conditioal formatting highlighting triplicates
- Replies: 5
- Forum: Excel Questions
