Frustrated with formula!!
Posted by Barry on October 18, 2001 5:34 AM
Can anyone help? I have a worksheet that has trailer numbers in a column (D10:D145)and the delivery dates in a column (F10:F145). I need to make sure there are no duplicate entries and if there are, I need to know which cells contain the duplicates (conditional formatting). At the bottom of the list I have the following formula =IF(MAX(COUNTIF(D9:D145,F9:F145 ))>1, "DUPLICATES","NO DUPLICATES") and the conditional format I have applied to these cells is this =IF(COUNTIF(D10:D145,D11)>1,TRUE,FALSE)and then I have the text bold and the cell color in red........is there a better way to do this.........because there's something wrong with what I have and I'm starting to get a little frustrated........please help!!