Hello,
Its my first real job where i need to use Excel and its lovely but i need some help from real pros.
I need some tips on how to speed up the process off cleaning the sheets, its over 10k rows and im been doing this for almost a month now.
I need to match Debit, Credit and plate number (swedish plates) . On the image plate number abc123 got -7000 and +7000. these need to be removed.
I have been using filters,condition formatting, pivot tables, everything is so slow...
Do you have any tips?
Thanks and sorry for bad english.
.
Its my first real job where i need to use Excel and its lovely but i need some help from real pros.
I need some tips on how to speed up the process off cleaning the sheets, its over 10k rows and im been doing this for almost a month now.
I need to match Debit, Credit and plate number (swedish plates) . On the image plate number abc123 got -7000 and +7000. these need to be removed.
I have been using filters,condition formatting, pivot tables, everything is so slow...
Do you have any tips?
Thanks and sorry for bad english.
![help.PNG help.PNG](https://www.mrexcel.com/board/data/attachments/113/113240-0ab0fd4553e16a002d08321e69441726.jpg)