• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formating on row for multiple condition

V

Viorel

New Member
Hello,
I need your help again.....("Help me Obiwan Kenobi, you are my only help....";))
I am in a big shit with a big sheet....
I have 15 columns (and more then 30.000 rows....) with information about sales. Problem is that i have many duplicate records (same customer, same product, same quantity, same invoice, etc.) and i need a method (conditional formating...?) to find and eliminating them all.
Please tell me what can i do to resolve that problem.
 
Last edited by a moderator:
Thank you Narayan, your sugestion was good but after i do that, my worksheet is very slow...
Anyway, thank you again and i thank's Somendra too....
You guys.... are very very good....
 
@Viorel

CF on 30,000x15 matrix will definitely slow down your workbook + this will be volatile. If this is one time activity, you must study Advanced Filter through the links I had posted on through any other links, it will be of great help.

1. It will reduce your 2 jobs to 1. First you want to highlight and than delete, it will automatically removes duplicates.
2. It will be faster.

Regards,
 
Hi, again.... I read about Advanced Filter..... but I still don't know how to apply that on my problem: How can apply Advanced Filter on rows for find duplicate records?
 
You must log in or register to reply here.
Back
Top