Vba excel function search jobs

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.

...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The...

I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.

I require a savvy Excel specialist who can effectively perform data analysis for a small volume of data. The data set to be input and analyzed has less than 500 entries and is composed of both numerical and textual data. Ideal Skills and Experience: - Excel proficiency - Previous experience with data analysis - Ability to handle both textual and numerical data The task will involve data entry and thorough data analysis to extrapolate insights from the dataset. Accuracy, attention to detail, and a keen analytical mind are essential qualities for this project.

I need an experienced Vue 3 developer to create a module that can display JSON data as a timeline visualization. Key Requirements: - Utilize Vue 3 for the development of the module - The primary function of the module should be to display JSON data extracted through axios, by using vis-timeline javascript library Ideal Skills: - Proficient in Vue 3 - Knowledge of data visualization techniques - Experience in creating interactive interfaces - Ability to work with JSON data - Strong communication skills to provide detailed project proposals. The successful freelancer should be able to not only develop the module but also present a detailed project proposal outlining how they plan to tackle this task. Please include previous work and experience in your application.

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I am seeking a developer to develop a third-party API of our platform which can be integrate in any other platform . The primary function of this API will be user authentication. Key requirements: - Integration of the third-party API into the website - Development of user authentication features - Support for multiple user roles with distinct permissions Ideal skills and experience for this project include: - Proficiency in API development and integration - Strong background in web development - Experience with user authentication systems - Familiarity with creating user roles and permissions - Excellent communication skills for ongoing support and troubleshooting

I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skilled in Excel, a...

...com/en/3d-model/various/slingbone-slingbow - Picatinny Rail at base of handle for flashlight/laser - Hollow Handle for Ammo Storage - Squared off Posts (similar to Scout XT below) but that fit Ocularis Plugs: - Front of Slingbow needs to have outward angle to function as cuban hand reel: - Angled Thumb Grooves on both sides like on the Scout XT: - Slot for Arm Brace such as is shown here: This project offers a unique opportunity to create a versatile tool that can be used for both hunting and fishing, so I'm

I need a search bar with a barcode scanner functionality for my WordPress site. The task is urgent and must be completed by 1 PM IST. Key requirements: - The search bar should be able to search products using the barcode, SKU, and product title. - The barcode scanner should be functional with both a phone camera and a barcode scanner device. - The entire feature must be integrated into an existing page on the WordPress site. Ideal skills and experience for this job would include: - Proficiency in WordPress development - Experience with integrating barcode scanning functionality into websites - Knowledge of different barcode scanner devices and their compatibility with web applications. I'll provide more details on the project to the awarded freelancer.

I'm looking for a professional to create a school management system using Angular. The system needs to be designed in a clean, simple design with a blue and white theme. Here are the features I expect to be incorporated in the school management system: - Gradebook Management: A function is needed for managing student grades efficiently. - Student Interaction: I'd like a chat feature that facilitates fruitful communication between students and their respective instructors. - Filtering Capability: The system should be able to filter student data based on chosen educational year and speciality. - Information Saving: It should save pertinent student information such as usernames and passwords, school year, and their selected speciality in Json format. Experiences in Angul...

We are working on a unique fitness training project focused on advanced gym-goers. The primary objective is to deepen their understanding of upper body muscle anatomy, ultimately enhancing their workout routines and achieving optimal results. This project requires: - In-depth knowledge of upper body muscle structure and function - Proficient in creating detailed, understandable materials for advanced gym-goers - Proven experience in fitness training, specifically strength training However, previous experience in designing learning materials centered on bodybuilding, weightlifting, or any relevant fitness training forms will be a definite plus. With your expertise, we hope to create an insightful and empowering platform that will greatly assist and motivate our advanced gym-...

As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.

...Vision API with their TEXT_DETECTION. More detail information from google on text extraction on remote image: The task involves extracting numeric digits using Google's TEXT_DETECTION feature from JPEG images hosted on a cloud server.: - Image URLs are provided in an Excel file (sample attached), with over 200 URLs. - The extracted numeric digits need to be added to the same Excel file in columns next to each corresponding image URL. We require only the digits with a length between 4 to 8 digits. Other text information is not needed. Google Vision API supports offline asynchronous batch image annotation for all features. The Google Vision API supports offline asynchronous batch image annotation for all features. https://cloud

...App is 75% completed by a former freelancer who has gone MIA. The application manages Mobile SIM Card ordering and ongoing support. The system is integrated with Zoho WorkDrive, Zoho CRM and Zoho Desk presently, however the Zoho Desk integration for the submission and updating of support requests seems to have some errors. The application is integrated to our soft switch to provide a testing function which I will go into more detail about with the successful freelancer. This has currently been tested through API integration to Enswitch, however needs finishing. We need further integration to our carrier/s through API for ordering, updating and cancelling of services. I have attached some documentation from the commencement of the project which will now need updating. I als...

We require a French-speaking AngularJS coder versed in creating effective student management systems. Ability to meticulously manage student data, especially personal information, is imperative. The coder must create a framework to handle and organize valuable data like notes, and year of study and what speciality... Additional functionalities like note taking a...like note taking and chat are required. Ideal candidates should have prior experience in managing student data system and be fluent in French. This project demands a meticulous approach to data management and privacy, with a focus on: I want database where students are stored and everything to be using json file.. - AngularJS - French Language Proficiency - Data management - Note and chat function integration - Privacy...

I am seeking a proficient software developer to build a comprehensive, cloud-based logistics and Supply Chain Management (SCM) software. Key Requirements: - Inventory Management: Create a system that seamlessly manages stock levels, keeping track of product volumes across different locations. - Order Tracking: Design a function that enables swift and accurate tracking of orders from inception to client delivery. - Warehouse Management: Implement an effective way to supervises goods in and out of the warehouse. - SaaS Logistics/SCM Capabilities: Develop the software to be cloud-based (SaaS) making it easily accessible and efficient for managers, staff, and clients. The ideal candidate will have sound knowledge and experience in SaaS product development and show proficiency in ...

I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...

...engine that can be used specifically on the PC version of the game Starve.io. (Mac and Windows) The Cheat Engine should ideally have the following features: - Unlimited resources: The ability to have as many resources as needed in the game. - Invincibility: A feature that makes my character invincible in the game. - Duplication: An option to duplicate items for an increased inventory. - Toggle Function for all cheats: I want to be able to activate or deactivate each cheat independently. I would prefer the Cheat Engine to be activated in-game through a menu. The ideal candidate for this job should have: - Experience in developing cheat engines or similar tools. - Proficient in programming languages relevant to creating game cheats. - Understanding of how to make the cheat eng...

I'm looking for a professional to assist me in setting up a new Amazon account for my company. The account will be used to list clothing items and drive sales. Below are the specific tasks and responsibilities I need help with: - **Account Setup**: I need a new email to be crea...product listings. - **Account Management**: While the project is focused on initial setup and listing, I'd appreciate if you could provide some basic guidance or tips on how to manage the account effectively. **Ideal Freelancer**: - Experience in setting up and managing Amazon accounts, particularly for clothing. - Proficiency in listing products on the platform, ensuring they are optimized for search and sales. - Good communication skills, as I'd appreciate some basic guidance for managin...

I'm in search of a professional sales specialist experienced in managing e-commerce platforms, specifically for physical products. The ideal candidate will: - Be knowledgeable in improving sales techniques and strategies. - Hold expertise in digital marketing and SEO strategies. Your main role will be identified in these two key responsibilities - enhancing our sales techniques as well as driving and implementing digital marketing and SEO strategies. Previous experience working with physical products on an e-commerce platform will be highly advantageous in optimizing conversion.

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and ca...

I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames...unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experienc...

Need to redesign . With calender function and mobile, tablet responsive design.

...quizzes. The goal is to enhance the visual appeal and functionality of the site, focusing on creating an intuitive and seamless user experience., I'm looking for a talented web designer with a strong grasp of Joomla to give my website a much-needed facelift. The ideal expert for this project will: - Apply a minimalistic update to the overall design of my site. - Optimize the site to perfectly function on mobile devices, giving as much importance to it as the desktop version. Your mission will be to improve the user experience by creating a simple yet effective interface. The aim is to remove any hindrances in navigation, enabling visitors to get the information they need without any inconvenience. A strong understanding of User Experience (UX) principles and mobile optimiz...

...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...

Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.

1. First code that r...reads token adresses from .txt or .csv file and reads if the token is found first time or it second if the first time then buys x amount of SOL or USDC (depends which one is better for you) then if the token adress was already found before then skip, search for other new token addreses in that .txt or .csv Then check current bought tokens price and if the price increased 100% sell out 50% of wallet total token holdings if the price increased 300% sell out 100% ot token, if the price from entry price went down to -90% take out 100% 2. Add function to that primary code before buying check if liquidity pool is locked and mintable then only enter if not skip and wait for new token adress Swap exchange does not matter I prefer Jupiter depends on the price an...

Seeking Experienced WordPress Plugin Developer We are in search of a skilled WordPress plugin developer to create a specialized system within a WordPress plugin. Here are the key functionalities we require: Service Contract Agreement: The plugin should incorporate a contract agreement form for customers and service providers. The form will offer three distinct service packages for customers to choose from. Package Selection and Checkout: Upon selecting a service package, the form's submit button will activate. After submission, the contract agreement form will be emailed to the customer. Simultaneously, the customer will be redirected to the checkout page to finalize the purchase of the selected package. An account should be automatically created for the customer during thi...

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key....

I am in search of a proficient Zoho Canva specialist who can assist me in graphic design and template creation. The design style should be minimalistic and clean, aligning with my company's branding. Key Tasks: - Designing custom templates on Zoho Canva - Ensuring a consistent style throughout templates - Focus on minimalist and clean graphic design These templates are intended exclusively for internal systems documentation. It would be beneficial if you have previous experience designing templates for software documentation or internal resources. Ideal Skills: - Prior experience with Zoho Canva - Proficient in graphic design - Experience with minimalistic design styles - Adept at creating documentation templates

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

I'm looking for a translator skilled in both English and Spanish education terminology to translate an Elementary level New Comer Math Assessment. The aim is to assist Spanish-speaking students grasp and excel in their math curriculum. This translation project covers topics in basic arithmetic operations. Candidates who have prior experience in education or translation in a similar field will be preferred. This project is particularly significant for enhancing accessibility and inclusivity in mathematics education for Spanish-speaking students. The successful freelancer will bring: - Proficiency in Spanish and English - Experience in translating educational materials - Understanding of basic arithmetic operations - Passion for education and inclusivity.

We required to develop some requirements to be done on Excel macro using office 365.

As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for ...

I'm in need of a skilled mobile app developer to create an Android-based platform that emulates the features of the popular Ola ride booking application. Key Features: - The app's primary function is to allow users to book rides conveniently. - It should integrate a robust and seamless real-time location tracking system for drivers. Ideal Experience: - Proven experience in developing Android applications. - Familiarity with GPS tracking systems. - Previous work on ride-sharing or booking apps is a plus.

...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...

Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi concrete market, one data point at a time!

...the Program' button on my Wordpress site, Currently, it's not functioning as desired. I want this button to link to the 'Contact Us' page on my website. Additionally, I require all necessary contact forms to be set up. Key Requirements: - Modify the 'Inquire About the Program' button to link to the 'Contact Us' page - Set up all contact forms to ensure they function correctly - Ensure that form submissions are emailed directly to me Ideal Skills and Experience: - Proficiency in Wordpress development - Strong understanding of HTML and CSS - Experience in setting up and testing contact forms on websites - Ability to configure form submissions to be sent via email This project is straightforward and shouldn't require too much time t...

I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.

...create a sleek, modern, and professional-looking website. The site will mainly serve as an informational hub for our company's latest news. Key Requirements: - Purpose: The primary goal of the website is to inform and engage business professionals. - Design: The website should have a corporate, professional, and easy-to-navigate design. - Content: The main content will be company news, so a function to easily update and publish news is a must. Ideal Skills and Experience: - Strong background in web design and development. - Proficiency in creating user-friendly, informative, and aesthetically pleasing websites. - Experience with content management systems for seamless news updates. - Previous work in creating websites for business audiences is a plus. Looking forward...

I'm looking to add a feature to the Houzez theme. It involves sending an email to the email that the person enters in the form when a user fills out the listing contact form. If this function is not possible, could it be that when the form is submitted, the user is redirected to a web page The email should contain: - A message to subscribe to our Aweber subscriber list I need this project completed within a month. Ideal Skills: - Proficiency in WordPress and the Houzez theme - Experience with creating custom email notifications - Familiarity with integrating Aweber or similar subscriber services into websites

I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.

I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.

I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the abil...

I am in need of an investment website that allows users to buy and sell stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and interactive p...

I'm looking to build an electronic device that predominantly monitors health. It will have a key feature of tracking blood pressure. Key Features: - Blood Pressure Monitoring: This will be the primary function. It should be accurate, reliable, and user-friendly. - Large Display: The device should have a large, easy-to-read display to make the readings straightforward and accessible. - Bluetooth Connectivity: I'd like the device to connect to smartphones and other devices, allowing for data tracking and easy sharing with healthcare providers or family members. Ideal Skills: - Experience in health monitoring device development, especially blood pressure monitors. - Proficiency in electronic device design and production. - Knowledge of Bluetooth connectivity and app integr...

I'm looking for a skilled developer to help me create a custom-built website, acting like an app store where users can easily download my app. The website will function as a platform for sharing app download links and will enable a review and rating system. I expect the website to be user-friendly and compatible with web browsers. Skills and experience needed for this role: - Proven experience in creating custom websites - Knowledge of UX/UI design to help create a straightforward and easy-to-use website - Familiarity with the creation and management of review and rating systems - Understand the process of making an app available for download through a website - Must be open to suggestions in terms of design and user interface Please note, the website's main purpose is ...