Excel VBA Script that Compares Rows with Criteria
$10-30 USD
Pagado a la entrega
We have some Excel Sheets with 20+ Columns and up to 100,000 Rows
We need a simple VBA script that compares each Row with all the Rows above it, one by one & cell by cell (eg. Row2 with Row1, Row3 with Rows 1&2, Row4 with Rows 1,2,3 etc.) and does some basic actions.
The comparisons are done between cells of the same column, not different columns
The script should be compatible with Excel versions 2010 and later
★Details★
In every comparison between two rows (eg. between N-th row and J-th row, where N>J), 3 things can happen:
1) RowN-ColumnA cell has same value with RowJ-ColumnA OR ColumnB cells. In that case the script deletes the N-th row and goes on to N+1 row
2) RowN-ColumnA cell has different value from BOTH RowJ-ColumnA AND ColumnB cells, but the 2 rows have cells of the same value in some other columns (eg. Columns D to N).
If the number of cells with the same value in columns D to N is above a NUMBER THRESHOLD we specify (eg. more than 5 common cells), then the script takes the value of the RowN-ColumnA cell and places it in RowJ-ColumnB cell. After that, the script deletes the N-th row and goes on to N+1 row
3) The 2 rows have no cells of the same value (or some common cells in Columns D to N, but less than the NUMBER THRESHOLD) so the script does nothing and goes on to the next row.
Empty cells are not considered to have the same value.
Cells must have a value for a comparison to be successful.
Nº del proyecto: #9066907
Sobre el proyecto
Adjudicado a:
Hello, I am Excel and VBA expert. I can complete this project. I have done several similar projects. Please note that I have 100% completion rate and 5-star feedback on projects.
29 freelancers están ofertando un promedio de $32 por este trabajo
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Más
Hi, I am an Excel macro expert and would be happy to take on your project. Please provide sample data to test. Regards, Arul
Hi! What I understood is that you need to re-arrange data based on certain criteria. I can help you out in this.
Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typi Más
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
I have the expertise in scripting in VBA for excel and can do the defined specification, accurately and quickly.
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. I have over 15 years of experience as Physics and Math teacher; but, I've also done some V Más
Hi I can do it by this night. I will use integrated loop. Please contact me for further details of your project. Thanks!
Hi It seems like an easy macro work, I want to see the file, if possible I need some of it solved as you mentioned. If sharing the file is not possible, if possible, please share a small sample of it. Regards, S Más
Hello , I would like to work on your project. I have great experience using excel and macros / vba. My strongest part is data manipulation in excel through vba code. I would like to work directly on your sample file. P Más
Hi, I am very good in EXCEL and VBA programming so I can help you with this project in minimal time. as I have worked on similar projects many times. Regards.
Dear Sir/ Madam I'm a professional VBA, VB and C# developer. I have 7+ years of experience in MS OFFICE and 4+ years of experience in VBA, VB and C# development. If you want your job done professionally and on time, Más
Hi, my name is Daniel, i can do this work just in 24 hrs or less, i have developed similar script and i am sure i can help you