Cell address based vlookup result macro excel jobs
Hello, I need an advertisement for a tourist map for Shooting Events: Advert size 122mm width x 132,2 mm tall: Shooting Events Pick-up & drop-off from & to your preferred address in Prague available daily from 9 AM to 8 PM 30-minute ride from the centre 2–2.5 hours total (from pick-up to drop-off) English speaking professional Instructor Guns rental • 1 to 70 guns based on the package chosen Gear • ammo, targets, eye & ear protection included in the price Refreshment • mineral water, soft drink Starting from 1800 CZK per person Book at
I'm seeking an Excel specialist with a high attention to detail, particularly proficient in pivot tables, data analysis, and data organization and capable with macros. The main tasks encompass: - Building pivot tables to consolidate our vast data - Conducting data analysis for sales and customer information - Structuring and formatting the data for better understanding and usage The specific datasets we'll be working with involve customer information and financial data, aiming to create comprehensive financial reports. This project forms a core part of our decision-making process, facilitating improved customer service, and enabling us to make data-driven business decisions. Ideally, you should have prior experience in medical finance or a similar field and be profic...
I am in need of a professional with strong skills in Wix, the Content Management System (CMS) for my website. Key Responsibilities: - Updates of text and images on my website -Management of the website Relevant Skills: - Proficiency ...of a professional with strong skills in Wix, the Content Management System (CMS) for my website. Key Responsibilities: - Updates of text and images on my website -Management of the website Relevant Skills: - Proficiency in managing Wix websites - Excellent graphic design, to ensure images fit perfectly on site - Excellent written skills for text edits - Attention to detail to detect and address any bugs or malfunctions This project will suit an individual who has a knack for maintaining websites and ensuring they function optimally at ...
I'm looking for a skilled developer who can create a simple but effective Minimum Viable Product (MVP) application for matching co-founders. Key Features: • User Profiles: The application must allow users to create individual profiles. • Interest-based Matching: Users should be matched based on their interests. This is an essential feature. A deep understanding of matching algorithms is required. • Chat Messaging: A basic chat messaging system should be in place to allow matched users to interact. Specifics of Matching Algorithm: • The algorithm should consider various interests such as business, tech and personal. • The goal is to facilitate synergistic matches between users. Ideal Experience: • Applicants with experience developing m...
I need a freelancer with a solid understanding of football, player performance analysis, and team tactics analysis. This project involves writing and publishing an insightful research paper on these topics. Key Requirements: * Experience in sports analytics especially within football. * Ability to analyze and interpret structured/tabular data (CSV, Excel, etc) * Strong understanding of player analysis and team tactics within football. * Excellent research writing and academic publishing skills. * I already possess data for this research. Knowledge in handling dataset is a must. Your main responsibility will be to handle all aspects of the research paper from drafting to publishing. You're expected to leverage the dataset I have to generate meaningful insights and conclusi...
I need a digital floor plan of an apartment. For this, I have the original dimensioned floor plans. The end result should look exactly like the example on page 2 in terms of style. The Budget is 10€.
I need a digital floor plan of an apartment. For this, I have the original dimensioned floor plans. The end result should look exactly like the example on page 2 in terms of style.
Hello, I am in search of an individual capable of designing a business plan. I have sample designs that I can provide for reference. I possess the business plan in Docx format and wish to have it converted to PDF format. The task must be completed within a two-day deadline. Successful completion of this project will result in additional projects.
I need to create several adaptive icons for Android from a sketch. The icons must adapt to the different Android formats. A vectorized and png file must be delivered with the Android requirements. You can test the result here: The idea is to make a circle for the backgroud image (see attached), and as the foregroud image the svg that I attached. The logo of our company is also attached so that you can obtain the colors to use. The sketch is made by me, I am not a graphic designer. Any advice on this will be welcome. Svg to foreground image are from fontawesome.
I require a seasoned data entry specialist with proficiency in Microsoft Excel to work on a part-time basis, specifically during evening hours from 8PM to 11PM. Requirements: - Advanced knowledge in Microsoft Excel - Capacity to work for 20+ hours per week - Experience with data entry jobs Although the role is part-time, reliability during designated work hours is essential. The ideal candidate will possess strong attention to detail and the ability to accurately input data. Prior experience working in similar roles will be highly regarded.
I am looking for a developer who can create a prototype chrome extension that is specifically tailored for ChromeOS. This extension should have a unique feature wherein it automatically connects to a specific wifi network when within detectable range. Otherwise, it allows to connect to any network. Needed Features: - Compatibility with ChromeOS - Auto-connect to a specified wifi network when within proximity - Permit user to switch to other wifi networks when the chosen wifi is not accessible Skills and Experience Required: - Proficiency in chrome extension development - Familiarity with ChromeOS - Strong understanding of wifi network connectivity protocols - Problem-solving abilities for unforeseen scenarios or inconsistencies during the extension's operation.
I need a professional with good experience in MS Excel financial calculations and an understanding of key financial modelling techniques such as NPV and IRR. You'll also need to write a short 850-word report based on the results of the calculations completed. Details to be discussed through chat.
Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ☺️ Thank You. Regards, Nimra
...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...
I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.
I'm seeking an experienced developer to create a messaging app available on iOS, Android, and Web platforms. The unique characteristic of this app is its anonymous, activity-based nature. - **User Roles**: The app will have multiple user roles - a coordinator, workers, and clients. Each user role needs different functionalities. - **Anonymity**: Communication between clients and workers should be anonymous. A client should be able to post a message and it should be delivered only to active workers. However, the worker's active status is managed anonymously. - **Notifications**: Workers should receive notifications about new messages in three ways - push notifications, emails, and in-app notifications. - **Attachments**: The app should also support file attachments so ...
I'm on the lookout for an experienced brochure designer. The piece must serve a dual purpose: promoting my pain specialist services and educating about common types of pain. Also want to promote our Stem Cell Therapy. The target audience is threefold: - Patients suffering from chronic pain - Healthcare professionals - General public Key design considerations: - It should project an air of professionalism and elegance. - Highlight pain specialist services - Include a layman-friendly information about common forms of pain. Required Skills: - Extensive experience in brochures design - Ability to translate medical terms in an easily understandable format - A good understanding of the healthcare field would be a plus - Excellent in typography and layout design - Strong knowl...
I am seeking an experienced blockchain architect to design a public blockchain model, primarily for smart contracts, based on the Ethereum platform. Requirements: - Expertise in blockchain architecture, particularly Ethereum. - Strong understanding and experience with smart contracts. - Able to design robust, secure, and efficient public blockchain systems. - Proven experience within the fintech industry is beneficial. I'm expecting high-quality design model for smart contracts, aligning with the best practices within the blockchain world. Let's discuss if you have the knowledge and experience I need. Please include examples of similar projects you've completed in the past. Your proposal should be detailed enough to give me confidence in your abilities.
TikTok Live Stream Host – Based in Latin America You must speak both Spanish and English. Please reply only in English. Questions 1. How many years of experience do you have creating content on TikTok? 2. How many years of experience do you have as a shoppable live streamer? 3. Do you speak both English and Spanish? 4. Please share your TikTok videos and channel(s). 5. Please attach your resume. Job Description I'm searching for a creative and talented content creator located in Latin America to conceptualize and produce engaging Spanish TikTok content. Please only reply in English. You must speak both Spanish (for the TikTok videos) and English (for communicating with the team) for this job. Key Responsibilities • Host the TikTok live streaming in English to ...
I'm seeking a professional who's highly proficient in Excel formulas, specifically those used for data analysis. The task involves working with sales data, therefore any previous experience with sales data manipulation is crucial for this role. Key responsibilities: - Derive insights from sales data using advanced Excel formulas. - Analyzing large data sets and using analytical toolbox of Excel. Ideal Candidates: - Advanced knowledge of Excel, specifically formulas. - Prior experience with sales data analysis. - Detail-oriented with the ability to manage large data sets. - Proven analytical skills.
I need the excellent services of a data entry expert to input text data from online sources into Microsoft Excel. The project requires keen attention to detail and proficiency in handling Excel. Ideal Skills: - Proficient Excel user - Fast typing speed - Acute attention to detail - Ability to efficiently extract data from online sources Experience: - Previous experience in data entry - Proven track record of using Excel for large-scale data entry operations.
I have Odoo v15 running on , and plan to use inventory module with lots and Packages Using barcode app v15.2 When doing inventory operations using barcode app, Odoo will pre-select the packages id to transfer based on a FIFO rule. But my company does not have perishable products, so the order of dispatch does not matter I would like Odoo to accept another package that is not already on the detailed operations, and grab it as good. Per example: I need to transfer 3 boxes of 10 units each Odoo proposes BOX1, BOX2, and BOX3 based on FIFO putaway rule If I try to scan BOX4, per example (same product, lot, etc but different box than Odoo says) it will put it in red and won't let me validate the operation I would like it to appear BOX4 in green and substitute BOX3, or ot...
I'm in need of a custom web application for my reselling business, which mainly deals with digital goods. Here's a quick overview of our operations: We operate by purchasing items from a...goods. I have a team in place that interacts with customers and facilitates the sale of our products. Our business model is such that we acquire items from our vendors on an as-needed basis and then sell these items to our customers through an online marketplace. Currently, we are managing our transactions using Excel sheets. Whenever a sale is made, the staff records it in a spreadsheet. I'm considering sharing a screenshot from one of our daily sheets for better understanding. Based on the data in these sheets, I calculate payments to vendors, wages for our staff, and ...
I'm in need of an experienced web developer to address and resolve 301 (Permanent redirect) Page with redirect, Alternate page with proper canonical tag, Duplicate, Google chose different canonical than user, Excluded by ‘noindex’ tag, Indexing errors flagged in my Google Console, to enhance my website's SEO performance. My primary communication method for updates and progress will be through Email. **Ideal Skills & Experience:** - Proficiency in website development and troubleshooting. - Extensive experience with SEO strategies and Google's guidelines. - Expertise in identifying and fixing 301 redirect errors. **Project Requirements:** - Analyze and identify all 301 redirect errors displayed in Google Console. - Plan and implement the best course of...
As a server administrator, I require someone with proficiency in managing Virtual Private Servers (VPS) to set up an nginx server. This entails the integration of a Wildcard SSL c...Additionally, it involves configuring the server to run through Cloudflare’s proxy service. This project requires: - Experience and deep understanding of nginx server setup - Skilled in VPS management - Comprehensive knowledge of SSL certificates with a preference for Wildcard SSL - Familiarity with Cloudflare's settings and a focus on the proxy service The successful completion of this project would result in a secure and well-configured VPS nginx server, operating with an integrated Wildcard SSL, and fully proxied through Cloudflare. This will enhance the security and efficiency of our ser...
I am in search of a talented Canva specialist who can assist me in creating a variety unique and impactful special effects. The purpose of these effects is not conventional, but think outside the box to create an effect that can enhance storytelling in a unique way. Key Requirements: - Extensive familiarity and proficiency with Canva. - Ability to think creatively and deliver innovative ideas within the platform's limitations. - Provide original and unique special effects concepts. Desired Skills: - Strong attention to detail. - Ability to handle multiple tasks and efficiently manage timelines. - Excellent problem-solving skills. Although there are no strict deadlines for this project, I appreciate a dedicated professional who is committed to maintaining a steady pace. If you'...
...at startup and must only require one key stroke by the user. At boot time of the OS 1. Automatically log in with root access (because of step 7) 2. Read the CPU ID from the board 3. Read the mac address from the onboard ethernet 4. Call an API: https://[host]/api/va/pool/[cpu id]/[MAC address] 5. Print the server response on the screen 6. Write 'place this device in the pool after you shut down the system by pressing ENTER' 7. Shut down the board You are free to use bash, python or golang. The following is immanent, but just to mention: - the OS must use DHCP to get an IP address and DNS - Location is Europe/Berlin - Keyboard is German/Germany Standard You deliver - a small description, ○ where the relevant scripts have been placed, ...
...professional who can help troubleshoot a problem I am experiencing while setting up a purchased PHP script from onlinepokerscript.com. This involves issues encountered during the configuration of Supervisor. • I would appreciate assistance from someone who has extensive experience in navigating and resolving similar issues. • Expertise in Ubuntu 22.04 LTS and PHP 8.1 is vital to effectively address and resolve this issue. • Your specific understanding of PHP script configuration and handling custom scripts is necessary. • During the course of this project, there will be a need to diagnose, troubleshoot and, eventually, fix the error I encounter in the configuration step of Supervisor, despite having installed all necessary dependencies. This minute understa...
My website logo is not properly aligned - it's not centered as it should be. I'm seeking a talented web developer who can quickly and accurately address this issue. Key tasks involve: - Verifying the current problem - my logo not being centered within the website header. - Making the necessary fixes to center the logo within the header. - Ensure the centered logo is compatible with different screen sizes and is responsive across various devices. Prior experience in website design and a good eye for aesthetics are preferred. Knowledge in CSS, HTML, and Javascript is essential for this job. Please reach out if you've ever solved similar alignment issues.
I am looking for a LABEL design for honey jars. Please read the requirements. Size is 2 inches x 3 inches landscape. Additional layouts will be a square and a round version. Our logo and colors must be in the design. -...will be a square and a round version. Our logo and colors must be in the design. - they are attached. Additional label requirements Statement of Identity must read: Pure Local Honey It must be in bold print, the type size must be comparable to the most prominent part of the label (larger than other type) and must be placed on the Principal Display (Front) Panel. Business address is required. The address is 1348 Pet Sites Rd, Chapin SC 29036 Net Weight must be placed at the bottom 1/3 of the design, to read 48 oz Must provide editable file...
I'm on the hunt for a talented graphic designer with a keen eye and strong understanding of Christian symbolism. This project involves creating a unique, Christian-themed t-shirt design, incorporating specified symbols like the Cross and Ichthys (Fish symbol). I want the theme to be based upon 2 Timothy 1:7. I'd like to have the items in quotes written on the t-shirt in some form or fashion "Fearless Faith", "2 Timothy 1:7", "Power | Love | Strong Mind". I want some image as well on the t-shirt such as a cross and/or an Ichthys Fish. I want the design to be for a screen-printed t-shirt that is either a one-color or two-color design. I'd like the design to be hip and trendy and possibly understated. Key aspects of the project inclu...
I need a proficient data visualizer to convert my raw excel data into easy-to-understand line charts and bar graphs. The goal of these charts and graphs is to display information in a visually appealing and digestible manner for both presentations and general visualization. Only looking for 2-3 visualizations for a very small set of data currently in excel table form (ie 5 data points of comparison between 2-3 company members). Here's what I am specifically looking for: * Conversion of data into line charts and bar graphs * Charts and graphs made should be presentation-ready * No specific color theme or design preference Ideal skills and experience: * Proficiency in Excel or similar software * Strong background in data visualization * Ability to prese...
I am seeking a highly skilled developer to create a chatbot that has capabilities to address frequent queries and customer service tasks. This chatbot will be integrated with Slack, and subsequently serve as an effective customer service tool, improving efficiency and user experience. - It must have the ability to process and respond to a wide scope of queries and have exceptional customer service features which allow it to interact consistently and effectively with users. - Importantly, the chatbot should also feature natural language processing (NLP) capabilities, giving it the ability to understand, interpret and respond in a more intuitive and human-like way. The ideal candidate for this project has: 1. Proficiency in chatbot development. 2. Good understanding and practic...
...algorithm/feature that matches these preferences with data pre-saved in the background in order to show users which team (from those pre-saved in background) matches them the best, based on these interests. Specifications: - User interest and relevance will be the main parameters for the matching algorithm. - There will be specific topics/categories users can express interest in - More will be further elaborated during a Zoom call. Ideal Skills and Experience: - Strong experience in website development particularly in building user interest matching features - Knowledge in data collection and analysis based on user input - An understanding of how to incorporate user preference rating scores into the system - Experience in processing and matching user data in the back...
I am searching for a proficient Excel specialist to design a concise tracking sheet for our company's business travel. This Excel sheet will keep track of both flight and employee details. Your task is to ensure that the sheet: - Efficiently records comprehensive information on each booking. - Offers easy generation of reports on these bookings. - Facilitates the monitoring of upcoming business trips. Vital flight details to include range from the booking reference, flight cost, to the departure date. Other notable data encompasses the traveler's name, department, destination, booking request, confirmation dates, the travel memo number, and the authorization information. The ideal freelancer for this project should have extensive experience building out detailed ...
I require an expert in QA testing to rigorously evaluate my mobile app and its backend. This individual will be tasked with: - User Interface (UI) testing: To ensure that the app's interface is user-friendly and operates smoothly. - Functionality testing: To ascertain that all features of the app perform as intended while making sure all bugs and glitches are identified and documented. - Performance testing: To guarantee that the app performs well under various conditions which includes stress testing, stability testing, and load testing. While I can provide limited access to the source code and documentation, I expect the freelancer to have in-depth understanding of Flutter and Golang, as these were the primary technologies used in the development of this project. Both Android and ...
I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order
I'm looking for a skilled graphic designer to create a custom business card for my company. This card should include my name and job title, as well as my contact details such as phone number, email address, company address, and mail. The size of the business card should be 92mm x 54mm. Key Requirements: - Incorporate specific colors for the design. - Add the company logo to the design. - Ensure that all information is presented clearly and professionally. The ideal candidate for the job is an experienced graphic designer with a keen eye for detail, and a demonstrated ability to translate brand identity into compelling visual designs. Expertise in color matching is crucial for this job.
I am looking for a developer to fix my project for sending SOL + signing Jupiter limit order transactions. The current project works fine communicating with Jupiter, obtaining raw TX data but then I attempt to sign & send the TX & get the response of "Transaction failed to sanitize accou...VB.NET using SolNet. Specific changes required: - Line 7 - Add MnemonicWords 12 Word Seed Phrase Using Ed25519Bip32 (SolFlare seed phrase generation method) (Current seed phrase in place as an example only, no balance) - Line 96 - SendTransaction Causing Above Error To Show (For TX Signing) - Line 116 - SendTransaction Causing Above Error To Show (For Sending To SOL Address) Reference For Jupiter Docs:
I'm seeking a talented UX/UI designer who can create a modern and intuitive onboarding experience for a web-based customer service tool I'm developing. The tool is conceived as an encompassing digital solution for businesses to manage and optimize their customer service efforts. Attached are preliminary Figma designs that we would look to implement (though open to improving these further). There will need to be integration with our platform as part of the sign-up process (similar to following topics in X when joining). Need a high-level proposal which lays out cost & timeline and examples of past companies you've built similar onboarding experiences for. Ideal Skills: - Prior experience designing onboarding experiences for web applications - Experie...
I am seeking a part-time administrative assistant with strong skills in Microsoft Excel. The main task will be data entry, so accuracy and attention to detail are crucial. Experience with handling large databases is a major plus. Skills and Experience: - Proficient in Microsoft Excel - Prior experience in data entry - Good attention to detail - Ability to work independently and efficiently - Understanding of database management is an advantage This is a remote position, so good self-management and reliable internet connection are also essential. Please include any relevant administrative and data entry experience in your bid.
I'm seeking a skilled designer proficient in Svelte to design a web application for library management. There are not too many pages - we have a list view for members, books, and transactions; each slightly different, with the book list view being the most complex. The list view must must support both a card and a table view. We also have settings, require a landing page, and statistics. Exact details can be discussed later on I currently use Bootstrap, but we can change the design stack as you like. We have a fairly clean look, but I want it be really impressive and responsive. PS: My budget for this is <2.5K, but you can take unto a month to complete.
I'm in need of a creative and detail-oriented video editor to revamp a short gaming video of mine, which is less than 1 minute. The task includes incorporating sound effects and impressive visual effects, and selectively zooming in at key moments to highlight the bridge closing onto my team mate, for comedic effect. Ill need a duck noi...portfolio showcasing similar projects - Ability to incorporate sound and visual effects creatively - Skilled at identifying key moments for zoom-in - Skilled at identifying swear words for censorship - Timely delivery is essential I look forward to seeing your amazing work! Here is a link to the 1080p, 60fps clip that needs to be edited. The clip will need to be the same resolution and FPS for the end result.
I am looking for an expert who can customize Excel sheet navigation to meet my specific needs. The successful candidate should be able to create an Excel sheet that: - Moves to the right when I press 'Enter' for the first time - Moves to the left and then down when I press 'Enter' again - Allows this unique navigation pattern to loop without the need for any additional keyboard inputs Skills & Experience Required: - Proficiency in Excel functionalities - Experience in VBA coding for Excel - Good attention to detail - Ability to complete tasks quickly and efficiently
My project requires implementing a conversion from specific sheets in an XLS file to XML. I would appreciate a freelancer who can: - Focus on converting only select sheets from the XLS file - Use the XML schema already provided - Handle complex data structures present in the XLS file The ideal freelancer should be comfortable with both XLS and XML file formats, a...I would appreciate a freelancer who can: - Focus on converting only select sheets from the XLS file - Use the XML schema already provided - Handle complex data structures present in the XLS file The ideal freelancer should be comfortable with both XLS and XML file formats, and have previous experience with complex data structures. Adequate knowledge in pivot tables and nested tables within an Excel environment will be b...
...include: - Well-chosen product images that really sell the clothing items - A prominent "Purchase Now" button - Genuine customer reviews to build trust and credibility - User-generated content, including photos and videos, to add authenticity - Clear, persuasive product features and benefits to help potential customers understand more about the products - A Frequently Asked Questions section to address common queries and concerns - Unique Selling Proposition and Social Proof icons to differentiate my brand from competitors and show that my products are loved by an array of customers If you're knowledgeable about conversion-centered design, have a knack for creating visually appealing landing pages, and are quick to respond, I'd love to hear from you....
Blue Carrot Video Production Studio is looking for a Motion Designer to work in Synthesia, no experience in Synthesia is required. By task: a script and an original video will be provided to get you started. As a result, you need to create assets in Adobe After Effects and then create a video in . Duration of cooperation: from April to May with the possibility of extension.
As a firm highly invested in our online security, we're seeking a skilled cyber security professional to undertake a one-off project centered around the analysis of our firewall logs. Primary tasks will include: - Detailed analysis of our firewall logs - Identifica...logs. Primary tasks will include: - Detailed analysis of our firewall logs - Identification of potential threats within these logs - Generation of comprehensive reports on any security incidents discovered We require these reports to be delivered, conveniently and in an easily navigable format, via Excel spreadsheets. Ideal candidates will possess experience in cyber security, specifically with a focus on firewall log interpretation and threat detection, alongside robust knowledge of Excel for repor...
We are an accounting firm based in Kwun Tong, Hong Kong. We are seeking assistance in preparing financial reports, including trial balance, profit and loss statement, balance sheet, and detailed ledgers. We will provide you with bank statements, invoices, and expense bills, and we would like the final result to be delivered in the Excel format that we have specified. If you interested it , please feel free to contact us to discuss for further details.
