Find Jobs
Hire Freelancers

VBA code for checking duplicate numbers in crossed rows

$10-30 AUD

Cerrado
Publicado hace más de 1 año

$10-30 AUD

Pagado a la entrega
I got variable row lengths with any numbers between 1 and 45 Eg 9 numbers in row 1, 12 numbers in row2 10 numbers in row 3 and so on. The number of rows vary as well could be any number of rows in a sheet. Each line must be crossed with all the lines in the sheet eg 10 lines will result in 45 crossed rows. The result of each crossed two rows must count the common numbers and only if the count in the duplicate numbers is 5 or 6 the those duplicate 5 or 6 numbers must be output on a new sheet. If the number of results is more than 500000 the results must continue to cells away from the first row result.
ID del proyecto: 34809452

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 1 año

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
27 freelancers están ofertando un promedio de $44 AUD por este trabajo
Avatar del usuario
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion.. Thank you Sandeep
$50 AUD en 1 día
4,9 (550 comentarios)
8,4
8,4
Avatar del usuario
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
$30 AUD en 1 día
5,0 (243 comentarios)
6,7
6,7
Avatar del usuario
Hi, I am well versed with Excel VBA and can help with checking of duplicate numbers. Please let me know if we can discuss more on this. Thanks
$30 AUD en 1 día
4,9 (195 comentarios)
6,8
6,8
Avatar del usuario
ID : 34809452 Greetings, We are interested to work on this project, please find my comments inline with yours. I got variable row lengths with any numbers between 1 and 45 Eg 9 numbers in row 1, 12 numbers in row2 10 numbers in row 3 and so on. The number of rows vary as well could be any number of rows in a sheet. Each line must be crossed with all the lines in the sheet eg 10 lines will result in 45 crossed rows. .... =>Ok, please share excel file with sample data, so we can analyse it more. We are Microsoft Access, Excel and SQL server database developers, about the experience my senior colleague has over 21 year’s experience and I have a 7 year of experience in building Microsoft access databases for various industry types and purpose, we do have contracts with couple of companies for long-term support. We had initial development of database for these companies. And on a ongoing basis we are making changes and/or supporting for bugs, improvements etc. We worked on over 530 Microsoft Access projects till now. It is a great tool when scaling-up and excellent reporting features.  We follow engineering methodologies, naming conventions. We do Documentation for ease of maintenance in long run. Regards Sonali
$20 AUD en 7 días
4,9 (92 comentarios)
6,4
6,4
Avatar del usuario
Hi I'll solve it via queries based on SQL/ADO/VBA coding in Excel sheet. Send me a sample Excel file for clarifing. Zurab
$99 AUD en 3 días
4,8 (47 comentarios)
6,2
6,2
Avatar del usuario
Hello, I am an Excel expert. I offer my services to create VBA code for checking duplicate numbers as per your requirements. We can discuss further details over chat. Please check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
$100 AUD en 1 día
5,0 (69 comentarios)
5,6
5,6
Avatar del usuario
Hi There, I'm ready to help you in VBA code for checking duplicate numbers in crossed rows . I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.com/projects/financial-research/Excel-Compiling-data/reviews Thank you
$20 AUD en 1 día
4,7 (90 comentarios)
5,4
5,4
Avatar del usuario
Hi there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks
$20 AUD en 1 día
4,9 (35 comentarios)
4,8
4,8
Avatar del usuario
Hi there. I am Excel VBA expert . I can do this project utilising my VBA skills and my experience in handling such jobs. Looking forward to working with you.
$20 AUD en 1 día
5,0 (9 comentarios)
3,0
3,0
Avatar del usuario
Hello, I am vba and excel automation expert and i am sure that i can build and app to check repeated numbers and output it in a new file. Please have a look at my profile for past projects and reviews. Thanks Arpit G.
$20 AUD en 7 días
3,8 (8 comentarios)
3,4
3,4
Avatar del usuario
Hi sir, it seems you want to do some processes on a variable length sheet, variable number of rows and columns. You need to count the duplicated values in every two lines but you need to represent the line with the max sheet width can be which is 45 columns. We can do that easily using Python and Python libraries and then extract the result as an Excel sheet, it will be much easier using VBA as the number of rows and columns are not fixed through the sheet, we can then create macros buttons in the excel sheet to use them easily whenever you press them. We can do that as follows: 1. We can create a button to fill all rows with columns to the width of 45 columns eg if a row has a value in columns 1, 3, and 10 it will then fill the rows to contain 45 columns with null values or the word 'NAN' for ex 2. We can create a button that find the duplicates for each 2 rows 3. And a button for publishing the results in the new sheet you want. I am a python developer with 2 nano degrees in data analysis and python from Udacity. I worked on several projects related to python programming, one of these projects was to investigate the TMDB movies dataset. I am also an Excel expert and VBA developer who has 2 certificates in VBA from NASBA and worked on similar projects in VBA such as creating full user-form data entry sheets for many firms, and integrated invoice creation between excel and word in VBA. I will be very happy if you contact me to work together, waiting for you, thank you.
$100 AUD en 2 días
5,0 (2 comentarios)
2,5
2,5
Avatar del usuario
Hello, I'm Hoang, a System Admin. I have 5-years of experience working with IT-Helpdesk position and Office 365 service. I think I can help you complete it soon. Please consider and contact me, we will discuss all the requirements/problems needed to resolve. We can remote access via TeamViewer or AnyDesk. Thank you.
$30 AUD en 2 días
5,0 (4 comentarios)
2,2
2,2
Avatar del usuario
Hello, I am a writer and expert in converting files from word to PDF along with checking grammatical mistakes. I am currently writing essays for the college students and preparing immigration documents for foreign workers and students established in Canada. I have successfully gained the approvals on the immigration matters with the documents I have prepared. I am expert in typing, Data entry in word, excel and converting files.
$25 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear hiring manager, I would like to let you know that I’m an expert in data entry freelancing and have been working for more than fev years. Hardworking and dedication is my passion that I always prefer to employ in my projects. I like to run after quality work that makes my client smile. I love in trial and I like to show you some examples that will make you confident to hire me. Honestly I am new in freelancing world but not in data entry world. I have successfully completed fev projects for our local organizations. Now this is the time to work internationally and spread my fake all over the world. My educational qualifications and diploma in computer science and technology made me more qualified for any type of secretarial and data entry job. All programs of MS Word is on my fingers & eyes including online data research. So, if you hire me, I am ready to start your project immediately with full work plan. I like to give you the best output you have ever seen. If you want, you can contact me through email, Skype and Whatsapp and any kind of communication methods. I’m eagerly waiting for your response. Yours sincerely Praful K.
$20 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. My Skills : ★ Data Entry (From Websites to Websites, to Software, etc) ★ MS Excel (Copy/Paste Data from PDF, Images, Website, etc) ★ MS Word (Formatting, Renaming, Conversions, Graphs, etc) ★ PDF (Conversions to/from Ms. Office, editing, splitting, forms, etc) ★ Data Processing (Retrieve, Transform, or classify information ) ★ MS Access (Convert Data from Excel to Access or Access to Excel) ★ Contact Details from Websites ★ PDF to MS Excel/Word ★ Image to MS Excel/Word ★ Typing in Excel/Word ★ Business Cards Data Entry, ★ E-commerce Products Listing, ★ WordPress Data Entry,
$20 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am an expert in Excel and VBA. I have done several projects in which I have done any task using programming in VBA. I can do it quickly and will provide you with quality and fast work. Can we discuss all your needs clear? Best regards.
$20 AUD en 7 días
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
Dear future client, I'm a Information Technology student, I'm good in doing data entry. As a student this project means a lot to me. Thank you God bless you
$20 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I saw your jobpost and Im very much willing to help you. I am knowledgeable in microsoft office as I am using it everyday. I am a bookkeeper and I love data enry as a side hustle. Just send me a message so we can discuss the detail. Looking forward to work with you.
$10 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I can get your task done by Excel and Python, and I will provide the source code in case you want to modify in the future, thank you.
$20 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi sir/ madam I am senior data analyst with advance excel and vba with automation for routine work. also, I can handle SQL, UiPath, please let me know I can help you further My top skills are:  Excel with advanced formula  Visual Basic  Excel Macros  Excel Reports  Pivot & Chart  Sales Analysis  Microsoft Word  Data Analysis  PDF  Data Scraping from Website by VBA  Outlook Automation By VBA Thanks Regards Suresh M Data senior analyst
$20 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Sydney, Australia
0,0
0
Miembro desde oct 1, 2022

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.