Find Jobs
Hire Freelancers

VBA code for checking duplicate numbers in crossed rows

$10-30 AUD

Kapalı
İlan edilme: 1 yıldan fazla önce

$10-30 AUD

Teslimde ödenir
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.
Proje No: 34809452

Proje hakkında

27 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 2 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
27 freelancer bu proje için ortalama $44 AUD teklif veriyor
Kullanıcı Avatarı
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 1 gün içinde
4,9 (550 değerlendirme)
8,4
8,4
Kullanıcı Avatarı
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
$30 AUD 1 gün içinde
5,0 (243 değerlendirme)
6,7
6,7
Kullanıcı Avatarı
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 1 gün içinde
4,9 (195 değerlendirme)
6,8
6,8
Kullanıcı Avatarı
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 7 gün içinde
4,9 (92 değerlendirme)
6,4
6,4
Kullanıcı Avatarı
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 3 gün içinde
4,8 (47 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
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 1 gün içinde
5,0 (69 değerlendirme)
5,6
5,6
Kullanıcı Avatarı
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 1 gün içinde
4,7 (90 değerlendirme)
5,4
5,4
Kullanıcı Avatarı
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 1 gün içinde
4,9 (35 değerlendirme)
4,8
4,8
Kullanıcı Avatarı
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 1 gün içinde
5,0 (9 değerlendirme)
3,0
3,0
Kullanıcı Avatarı
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 7 gün içinde
3,8 (8 değerlendirme)
3,4
3,4
Kullanıcı Avatarı
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 2 gün içinde
5,0 (2 değerlendirme)
2,5
2,5
Kullanıcı Avatarı
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 2 gün içinde
5,0 (4 değerlendirme)
2,2
2,2
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
5,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 2 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   AUSTRALIA bayrağı
Sydney, Australia
0,0
0
Eki 1, 2022 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.