avoid repetitions in excel

  • Thread starter Thread starter aosewa
  • Start date Start date
A

aosewa

I am currently updating an excel worksheet created earlier on by
someone else, How can I ensure EXCEL checks for any previous occurence
of the rows similar to my new updates so I do not populate the
worksheet with redundant repetitions ?
 
How is a macro going to understand the concept of "similar"?
As a workaround, maybe adding a keyword column and bubblesort it.
 
You must log in or register to reply here.

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 avoid repetition of values in a row or a column? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Software for "repetitions" 5
Cut & Paste in Excel without erasing cell borders? 1
trying to create a link to a link in Excel (2007) 3
simple but repetitive use of combobox 0
Excel 2010 Table not showing in Access 2010 Import List 0

Back
Top