Excel VBA Script that Compares Rows with Criteria

Completado Publicado Dec 7, 2015 Pagado a la entrega
Completado 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.

Excel Arquitectura de software Desarrollo de software Visual Basic

Nº del proyecto: #9066907

Sobre el proyecto

29 propuestas Proyecto remoto Activo Dec 8, 2015

Adjudicado a:

macroPOL

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.

$25 USD en 1 día
(22 comentarios)
4.6

29 freelancers están ofertando un promedio de $32 por este trabajo

zExcel

A proposal has not yet been provided

$65 USD en 1 día
(225 comentarios)
7.3
jaylancer43

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

$34 USD en 1 día
(211 comentarios)
6.9
deepbluetech

Hi, I am an Excel macro expert and would be happy to take on your project. Please provide sample data to test. Regards, Arul

$50 USD en 1 día
(247 comentarios)
6.8
P0L

A proposal has not yet been provided

$30 USD en 2 días
(53 comentarios)
5.7
someka

Bir öneri henüz sağlanmadı

$64 USD en 0 días
(58 comentarios)
5.2
Khurramz

Hi! What I understood is that you need to re-arrange data based on certain criteria. I can help you out in this.

$34 USD en 1 día
(85 comentarios)
5.1
zebracaro

I can d it for you quickly and exactly .

$25 USD en 0 días
(49 comentarios)
4.9
rajafaizan

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

$82 USD en 3 días
(25 comentarios)
4.4
slenders13

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

$30 USD en 1 día
(18 comentarios)
4.4
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc Más

$55 USD en 1 día
(4 comentarios)
4.1
surekash7096

I have the expertise in scripting in VBA for excel and can do the defined specification, accurately and quickly.

$25 USD en 1 día
(31 comentarios)
4.4
BDtW

Hello I am Shahed from BDtW. Thank you for the kind explanation of your requirements. We have read your project description, discussed it thoroughly and believe we can deliver it perfectly. We have understood al Más

$24 USD en 1 día
(21 comentarios)
4.1
milanmartinjuk

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

$25 USD en 1 día
(20 comentarios)
3.8
lashabuxo

A proposal has not yet been provided

$25 USD en 1 día
(6 comentarios)
3.4
jnekam

Hi I can do it by this night. I will use integrated loop. Please contact me for further details of your project. Thanks!

$25 USD en 1 día
(6 comentarios)
3.7
serdaryalcin

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

$21 USD en 1 día
(12 comentarios)
3.6
nagyzoltan68

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

$25 USD en 1 día
(15 comentarios)
2.9
MoohHHooM

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.

$20 USD en 0 días
(6 comentarios)
3.1
MinhLeNguyenAnh

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

$23 USD en 1 día
(2 comentarios)
2.2
y2klewis

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

$15 USD en 1 día
(3 comentarios)
1.5