Find Jobs
Hire Freelancers

Apply Auto-Sort formula in Excel

$15-25 AUD / hour

Completed
Posted about 7 years ago

$15-25 AUD / hour

I have a basic spreadsheet with 7 columns and I would like to have the final column auto sort in ascending order every second or so and also produce a sound when a result appear greater than a certain figure. The data in the spreadsheet feeds off an RTD or DDE feed so it is always changing.
Project ID: 13611693

About the project

27 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
I have excellent command on MS Excel and can write a macro to auto sort data every second. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the website's API - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
$15 AUD in 40 days
4.8 (85 reviews)
5.9
5.9
27 freelancers are bidding on average $19 AUD/hour for this job
User Avatar
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I always take project to completion. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$21 AUD in 10 days
5.0 (782 reviews)
8.6
8.6
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
$15 AUD in 40 days
4.9 (387 reviews)
8.2
8.2
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. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3). If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$20 AUD in 20 days
4.9 (309 reviews)
7.7
7.7
User Avatar
i can do it for you quickly and exactly
$16 AUD in 40 days
4.9 (116 reviews)
7.1
7.1
User Avatar
Hi , I have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. Please ping back to discuss the requirements , so that I can propose solution. Why i should be Hired ? I have very good experience 100% accurate solution 100% Time compliance Good Communication I am sincere,honest and hardworking independent freelancer. I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
$15 AUD in 8 days
4.9 (162 reviews)
6.0
6.0
User Avatar
Hello. I have an experience with VBA and I could make a good solution for your task. Could you provide the example?
$16 AUD in 2 days
5.0 (42 reviews)
5.5
5.5
User Avatar
- Can get the data with the 7 columns sorted every time occurrence. - Have done similar LeaderBoard, where the data gets populated in the Excel file, but based on the gaming, number of players and certain conditions it would populate the outputs automatically no manual intervention. (Freelancer project). - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$15 AUD in 5 days
4.6 (51 reviews)
6.0
6.0
User Avatar
Hello, I have 9+ years of extensive experience in Web automating data transformation/presentation tasks in MS Excel via the use if inbuilt functions/custom macros and VBA code. I have read the project description & should be able to assist you with this specified task of yours in a swift manner. We can connect over chat and discuss it further. Please do let me know in case you would like me to assist you. Looking forward to hear back from you. Thanks and Regards, Abhinit
$15 AUD in 20 days
4.9 (17 reviews)
4.3
4.3
User Avatar
I'm working in a reputed company having an experience about 6+ years. I'm an IT data analyst and will be able to deliver your project on time. Hire me and get it done professionally with atmost satisfaction. Cheers
$18 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day. I am good at Excel VBA and data entry. I was used to work by Excel until. If you have any question, please feel free to contect me. Hope to have a change to work together.
$15 AUD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore your needs, which will yield a clear picture of implementation phase. Prior undertaking project, I want to show demo of the work done previously. Apart from demo, I will be sharing following documentation which will turn your project into Quality and Successful delivery: - Technical Project Proposal - Designs - Flow chart for this Project - Execution plan Thanks.
$25 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm interested in the project that you offer. I'm a hardworking/workaholic person. Eager to finish the job or project with the right accuracy. My typing speed is 60 to 80 wpm. (Above average user in MS WORD, EXCEL and POWERPOINT) I can do the job on/or before the said deadline, with minimal errors. I can do DATA ENTRY, FILL IN SPREADSHEET, COPY WRITING, PROOFREADING, JPG TO WORD and may more. As long as you provide the steps or procedure, in your said project, I can do the job right away.
$22 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in excel data management and auto command. I will conduct your task with short time ensuring the 100% quality. I will deliver project as per the requirement of Clint.
$16 AUD in 45 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experienced in data analyzing using Microsoft Excel package. And also I am experienced in data entry as well.
$15 AUD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, I'm James a developer from London. Your project caught my eye and I'd like an opportunity to discuss it further with you. Please feel free to read reviews and look at examples of my work. Cheers
$22 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 20 years of experience with Excel and efficient ways of gathering, cleaning, and entering data into the application. I am also able to analyze the data, extract information and draw conclusions from it in order to support business decisions. Once I understand the project I'll be able to submit a firm proposal ( I am new to freelancer.com... So I am not totally sure how the process works and how I am supposed to bid on a project if I don't have any information about it). Sorry if I sound like a freelancer.com "newbie" but this is what I am, I am learning the process. Thanks, Abner Wilding 954-232-8135
$17 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further on personal chat. Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end. Following are my Expertise Area: 1)PHP with CodeIgniter and Laravel Framework. 2)Node JS 3)Angular JS 4)Mobile App Development Thanks :-)
$20 AUD in 40 days
0.0 (0 reviews)
3.4
3.4
User Avatar
Hi, my name is Mike, I’m based in Oxford, UK. Your project description sounds interesting to me and I do have skills & experience that are required to complete it to a high standard. I can show you some examples of my work that are similar to this. Let me know when you’re available to go through it in more details.
$22 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
5.0
2
Payment method verified
Member since Sep 9, 2015

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.