Excel functions/formulas

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Trying to set up my spreadsheet so that when I enter a
value into a selected cell Excel will then search the rest
of the spreadsheet and delete/mark/highlight any duplicate
values from the cells it finds it in.
 
Matt
The scheme you would use involves using the Find function in VBA. You
would use a loop to run through successive cycles. In the first cycle you
would use the "selected cell" as the "Look After" cell in the Find function.
When it finds the "next" instance of that value, and that cell is not the
same cell as the previously found cell, then it would highlight or whatever,
that cell.
The next cycle would use the cell just found as the "Look After" cell in
the Find function and so on until the found cell is the same as the
original "selected cell".
Post back or contact me direct (remove "nospam" from my email address)
if this is not clear or you need help with it. HTH Otto
 
Trying to set up my spreadsheet so that when I enter a
value into a selected cell Excel will then search the rest
of the spreadsheet and delete/mark/highlight any duplicate
values from the cells it finds it in.
Click to expand...

You can highlight duplicates by using conditional formatting, so long as you
are not going to run afoul of the three condition limit due to using this
feature in the same cells you are testing.

To delete those values would require a VBA event macro.

Can you be more specific?




--ron
 
Back
Top