Is there a formula that can spot duplicate reference des's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that will spot duplicate reference diesignator's such as if
you have mo9310 more than once, the cell will say ref! or change color.
 
another choice
u also can use Data formatting to change the color
i.e table_array:range("a1:a10")
choose a1>data formatting>cell value "=countif($a$1:$a1,a1)<>1" set the
color >then drop down(just copy the format)

PS.while u use the excel 2007 it will be more easy cas it privide this
rules.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to find #ref! invalid cell references within cell formula 6
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
is there a simple formula that will remove all duplicates 3
Data Validation, Identify Duplicates and Limit imput 7
Mapping integers to strings 5
Excel Subtotal without calculate duplicate lines 4
Duplicate Function Help 1
make a list from another list ignoring duplicate entries from orig 1

Back
Top