Find Jobs
Hire Freelancers

Write excel vba code

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
Every column in MS Excel will have unique values. Each value can be single letter or up to ten letters and unique in the column. Every column has five to 100 unique values. Every column has header with dates. Number of columns can be from 2 to 60. Multiple columns can share each unique value of each column. Need someone to write a simple code for MS Excel to count unique value in each column across all columns and tabulate date wise. For example 1X23 is in ten columns. Result will be unique value, count and dates. Unique value with max count will be at top and unique values will be in descending order. Latest date will be first and older date will be last. Need the VBA source code to execute in MS Excel
Project ID: 15231475

About the project

40 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Yes, I understood your requirements. Please share excel with sample data. I can reply you with excel VBA in a few hours. Thanks! Relevant Skills and Experience Excel, VBA Proposed Milestones $29 USD - macro
$29 USD in 1 day
4.8 (190 reviews)
6.0
6.0
40 freelancers are bidding on average $28 USD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. Proposed Milestones $50 USD - Please pay me once the job is 100% complete
$50 USD in 0 day
5.0 (617 reviews)
8.3
8.3
User Avatar
Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with excellent knowledge in Excel, Visual Basic. please give me a chance to work on your project Proposed Milestones $50 USD - Once the project is complete
$50 USD in 1 day
5.0 (269 reviews)
7.5
7.5
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
4.9 (275 reviews)
7.2
7.2
User Avatar
Interesting problem - I can write a macro to identify and generate a table of all unique values, their count and dates of occurrence in the order that you need. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 15 MONTHS , spent at least 250 HOURS on automation in Excel every month. Proposed Milestones $20 USD - Automation as per requirement
$20 USD in 0 day
5.0 (162 reviews)
6.7
6.7
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VBA code. Proposed Milestones $28 USD - Deliver final and fully functional version tested and approved by you. When can we chat or talk? I am online from 3 to 11 pm (GMT+3).
$28 USD in 1 day
4.9 (152 reviews)
6.8
6.8
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Aman
$29 USD in 1 day
4.9 (168 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.9 (255 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (118 reviews)
6.4
6.4
User Avatar
Hi Relevant Skills and Experience I am good in excel vba and macros Proposed Milestones $25 USD - `
$25 USD in 1 day
4.8 (52 reviews)
6.1
6.1
User Avatar
A proposal has not yet been provided
$12 USD in 1 day
4.9 (65 reviews)
5.7
5.7
User Avatar
Hi, dear here need sql/ado/vba coding within Excel. Relevant Skills and Experience Excel,vba, sql,ado Proposed Milestones $30 USD - default
$30 USD in 1 day
4.7 (31 reviews)
5.8
5.8
User Avatar
My approach offers a macro with the usual Open file dialog to identify the current input and output files and and other controls if necessary. Relevant Skills and Experience I have a university degree in economics and IT and several decades experience in system design and programming in Excel and VBA. Proposed Milestones $25 USD - Whole project. Additional Services Offered $0.01 USD - Consult details, test pilot solutions, use of macros, fixing of bugs and minor changes are free. $0.01 USD - Further use of macros, fixing of bugs and minor changes are included without any additional fees. $0.01 USD - I can start working on the project immediately and complete the job within some hours. Send me a sample file, I'm ready to create a free draft pilot for you.
$25 USD in 0 day
4.9 (62 reviews)
5.7
5.7
User Avatar
I understand your requirement. I can design a complete algorithm on Excel VBA Code to achieve your goal. I have 7 years of experience. See my profile for client reviews. Relevant Skills and Experience Excel VBA Proposed Milestones $25 USD - only Looking for your response.
$25 USD in 1 day
4.8 (34 reviews)
5.6
5.6
User Avatar
Hi. I have a great skill in Excel macro. I can complete your project. My price and period is negotiable. We can discuss details via chat. Thanks. Relevant Skills and Experience I have much experience in Excel macro. Proposed Milestones $35 USD - done
$35 USD in 1 day
5.0 (8 reviews)
5.1
5.1
User Avatar
Hi, I am an expert excel worker and I do programming on VBA Excel to gather data from internet automatically. So that I am the suitable one you are searching for, Sir. Thanks. Relevant Skills and Experience Web Search Web Scrapping Excel Data Processing Data Collecting (Using Macro) VBA Mathematics Excel VBA Macro Automation User Forms Data Analyzing Proposed Milestones $25 USD - Final
$25 USD in 0 day
5.0 (30 reviews)
4.9
4.9
User Avatar
Hi, as per your requirements, I will give you a complete system to automatize your manual work with high class data analysis features. This system will be designed with your specific requirements. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. have excellent knowledge and experience of Manipulating Data in Multiple Sheets and Creating Reports. I have done mostly Excel VBA Programming job. Proposed Milestones $35 USD - final
$35 USD in 1 day
4.8 (62 reviews)
5.2
5.2
User Avatar
I am sure that my work will be completed in 3 days and will be paid for $ 11 Relevant Skills and Experience I am skilled in using AutoCAD, SolidWorks, Excel and other software, and I use their VBA tools developed Own tool software, improve my work efficiency. Proposed Milestones $11 USD - 1 days to submit program, confirm and modify
$11 USD in 3 days
5.0 (4 reviews)
4.4
4.4
User Avatar
Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle Proposed Milestones $150 USD - complete
$150 USD in 3 days
4.8 (19 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
5.0 (8 reviews)
3.1
3.1
User Avatar
I have extensive experience working on projects that require excel VBA skills.
$20 USD in 1 day
5.0 (2 reviews)
2.4
2.4

About the client

Flag of UNITED STATES
Troy, United States
5.0
2
Member since Sep 22, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.