Excel vba function return array jobs

I need a data entry specialist to clean a dataset to be used for reporting and analys...the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deliver a clean dataset suitable for report...

I'm in need of a seasoned Flutter Developer, proficient in creating cross-platform mobile applications for both iOS and Android. The core function of the app is to serve as a dynamic and interactive social networking platform. Key features of the job include: - Experience in previous mobile app development projects - Strong knowledge and expertise in Flutter - Proven track of record in creating social networking apps Your responsibilities: - To design and build a responsive and user-friendly social networking app - Ensure that the app is compatible and fully functional on both iOS and Android platforms. Your expertise in the techniques and trends of social networking apps will be greatly valued.

I'm seeking a talented designer to assist with our company rebranding. Here's a brief of what we're after: - A fresh and unique rebranding design concept. - As the company name and specific services weren't stated, we're looking for someone who can provide a wide array of design services or is open to collaboration on multiple fronts. Ideal skills and experience for this project: - Strong experience in branding and rebranding initiatives. - Portfolio demonstrating a broad scope of work in different design streams. - Availability to collaborate and communicate on refining our brand vision. I look forward to seeing how your creativity can benefit our brand transformation.

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and functional...

I am in need of a proficient developer to create a platform that garners reviews from both mobile applications and websites. The core function of this software development project will be: - Collecting both user-submitted text and star ratings - Presenting these collected reviews on Google maps Ideal Skills and Experiences: - Experience in web and mobile application development - Familiarity with Google map APIs is susceptible - Strong grasp in designing intuitive, user-friendly interfaces - Previous experience in developing review or survey related tools This project is multi-faceted and has an influence over a wide audience, therefore the ability to deal with complex projects is paramount.

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I need a Google Sheet that will serve as a simple database for my business. Here's what I need: - Data entry and storage: This is the primary function of the sheet. My team will need to manually input data into the sheet on a regular basis. The sheet should be well-organized to easily accommodate new entries without compromising the existing data. - Access control: Only I, as the owner, should have the permission to edit the sheet. It's important that this access control is robust to maintain data integrity and security. I'm seeking a freelancer who is proficient in Google Sheets and can deliver a simple, user-friendly, and secure solution for this project. Experience in data management, user access control, and business data storage would be a plus. Your bid shoul...

I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking...Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management a...

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will be highly regarded.

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...

Please read all the photos before deciding whether to do it or not. Be sure to complete the function of selecting variants at the front desk and the data will be switched simultaneously. I'm looking for a skilled developer who can create a custom WordPress plugin for my personal e-commerce website. The main focus of this project is to enhance the user experience and streamline workflow by enabling: - Automatic synchronization of background variant products to tabpress and size guides. - Dynamic change of product attributes such as SKU, weight, length, width, and height based on selected variants on the product page. - Customization of product selection and display. The ideal candidate for this project should have: - Proficiency in WordPress development and plugin creation. -...

Please Sign Up or Login to see details.

I'm in need of a skilled developer who can integrate Stripe payment into our current CRM system, which has an open API. The main function of the integration will be to track payments. Key Responsibilities: - Integrate Stripe payment system into our CRM - Ensure seamless payment tracking functionality - Testing the integration to ensure it's functioning correctly - Provide documentation on how to use the integration Ideal Skills and Experience: - Proficient in using Stripe APIs - Experienced in integrating payment systems into existing systems - Familiar with CRM systems and how they interact with external APIs - Strong problem-solving skills and attention to detail If you possess these skills and have prior experience in similar projects, I'd love to hear from you....

I am looking for a skilled designer to create a poster and matching return card for a dinner. Wording is attached. The poster size should be 8 1/2 x 5 1/2 and the attached card should be 5 1/2 x 4 1/4. Also attached are some of our previous designs which you can use for inspiration. Please create a new look for this year. Ideal skills and experience for this job include: - Proficiency in graphic design software - Experience in creating posters for formal events - Ability to work with custom sizes and formats - Strong attention to detail and an eye for design aesthetics If you think you have the skills and experience needed to create a stunning poster for my event, please submit your proposal. I look forward to seeing what you can come up with!

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formatting is an...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

I need a skilled VBA developer who can help with an important task -- Macro Programming. The main purpose of this programming will be to improve the output of data in a more coherent and meaningful way. Here's what the project involves: - Macro Programming: I am specifically looking for someone who can build macros in our system to ease the process and make it more efficient. - Data Output Formatting: The second important part of the task is to navigate data output formatting. Even though I haven't specified the kind of formatting, this is a crucial aspect of the job. Skills and experience necessary for this project include: - Proficiency in VBA development and Macro programming - Experience in managing and manipulating data - Skills in data output formatting...

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals

business profit loss reporting excel(Jan, Feb & March)

...I require the person to be Australian based The main tasks include: - **Interactive Forms Implementation:** The developer should be able to create interactive forms that are user-friendly and smoothly integrate with our current web page. This will involve a combination of design and programming skills to ensure a seamless user experience. - **Shopify Linking for Event Ticketing:** The main function that needs to be implemented is a robust ticket sales tracking system. This will involve setting up a connection between our web page and Shopify, ensuring that ticket sales data is accurately tracked and reported. Ideal skills and experience for this project include: - Proficiency in HTML/CSS and JavaScript. - Previous experience in creating interactive forms. - Experience in int...

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...

...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...

I browse to a text file containing a ...If there is an app that allows a TXT definition like what I am saying, then I would consider buying that, but I tried that and this gig is really for having it developed. Search for FLOWCHART and click on IMAGES and you'll see hundreds of examples. Include: 1. Source Code 2. Compiled Code 3. User documentation. 4. Technical (programmer) documentation: Technologies used, overall flow, for each function/subroutine what the input and output are. Should be 1-2 pages (the more the better.) 5. I get a week to test it. At first you can run it. When it's working I'll test it myself. If I find bugs they are fixed and I get another week. But before we talk you need to tell me what 49 is. Actually let's make it better. Take t...

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I'm looking for an expert who can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-depth monthly breakdown of these values. Skills & Experience: - Proven track record in financial analysis, specifically real estate and multifamily property market. - Professional approach with strong attention to detail. - High-level proficiency in using proforma software or Excel. - Understanding of the specifics of rental property cash flows.

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

...Arduino Leonardo or ESP32. The goal is to simulate pressing the Z1 keys solely through software, without external devices. Activation should be tied to the Caps Lock LED status—active when on, and inactive when off. Solutions utilizing 'keybd_event' and 'SendInput' do not meet the requirements of this project; a deeper, more intrinsic approach is necessary. Conditions: The keyboard emulator must function correctly within the game. The project must be compatible with Windows 10. Candidates should be proficient in at least one of the following programming languages: C++, Python, or Pascal. Payment will be made upon successful demonstration of the emulator working within the game. Note: This project does not involve breaking any game's security measu...

The WhatsAp... the bot greets them and requests input of a code or menu name (there are 200 codes or menu names available). 2. If the input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code • Return to the main menu For subscribers: 1. Information from PDF files or images is sourced from a different folder. Alternatively, information in text form is more common. open source e...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm seeking a skilled PCB circuit designer to create a digital circuit f. The primary function of the circuit is PWM Motor Speed Control Key requirements: Input supply voltage: DC 2.5V-25V The maximum output power: 350W The maximum continuous output current :15A The overload and short circuit protecting current is 25A PWM frequency: 25-30kHz Duty Cycle adjustable: 0-100% The operation environment temperature:-20℃-40℃ Ideal freelancer would have: - Proven experience in digital PCB circuit design - Strong knowledge of signal amplification principles - Familiarity with radio technology and its requirements - Ability to optimize circuits for low gain

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I'm seeking a mobile app developer with experience in developing TV applications. The project involves the creation of a TV app that would support live TV streaming specifically. Here are the project specifics: - **Primary Feature**: The main function of the app is to support live TV streaming. This is the core feature that will require meticulous implementation. - **Content Categories**: The live streaming feature will specifically focus on TV content. This includes channels that cater to TV shows, documentaries, or other related TV broadcasts. - **Device Compatibility**: The app should be compatible with Samsung and LG smart TVs. The ability to ensure the app runs smoothly across different models of these brands is crucial. Ideal candidates should have: - Proven experien...

I am looking for an experienced CNC programmer to help me program M codes on my Syntec 60W-e CNC controller. I have 3 unused out relays that I want to use, and I would like each of them to be assigned to specific M codes. Here’s what I need: - Assign M code e.g. M30, M50 and M80 to the unused output relays. - The function they should perform is to turn an external device on/off. Skills and Experience: - Previous experience with CNC programming is crucial. - Familiarity with Syntec 60W-e CNC controller will be highly advantageous. - Proficiency in M code programming required.

I have a iOS application with a few bugs that needs fixing and adding the function of inviting phone contacts to our app. iOS application built in: - Objective C - Native App and UIKit I will share the specification document when we speak in freelancer chat.

Help add search filter to iOS Swift App that exposes the selected items in the array (selected indexes) and the selected index if only 1 is returned.

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

I need an experienced VB.net programmer to make modifications to existing source code. The project itself should include feature demonstration forms. Key Responsibilities: - Modify existing source code: The main task will involve working with the existing codebase, making necessary adjustments, and ensuring the software continues to function as expected. - Demonstration forms: The project includes creating feature demonstration forms for the software. Ideal Skills and Experience: - Proficient in VB.net: The candidate should have a strong background in VB.net, with practical experience in modifying and building upon existing code for file IO, object generation and file parsing for data output. - User Interface Development: While the project involves existing source code, a good u...

We are seeking a skilled freelance writer to create comprehensive documentation and set up demo data for our company's Customer Relationship Management (CRM) processes. The primary responsibility will be to research and document our existing CRM workflows, procedures, and best practices, as well as create sample data for d...proposal with the following: Your rate or fixed-price quote for the project (Budget: Max Rs. 1000 INR only) A writing sample demonstrating your ability to create clear and concise documentation Your availability to start and estimated timeline for completion We will provide demo login credentials for the GrowCRM system. Although the budget is strict at Max Rs. 1000 INR, we can offer good reviews in return for quality work. We look forward to reviewing yo...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.