Cell address based vlookup result macro excel jobs

...profiling: The system should be able to create and modify dynamic profiles for each user to better understand their typical transaction behavior. - Integrations with ML/Python Components: The system should be able to integrate with existing ML/Python components to enhance its functionality. - Workflow and Case Management: The system should be capable of managing the workflow and cases that arise as a result of flagged transactions. - Reporting, Analytics, Data Pipeline: The system should provide detailed reporting, analytics, and a data pipeline to ensure that information is properly documented and stored for future reference. - Other: Further details about the system's functionality will be discussed with the right professional. Ideal Skills and Experience: - Strong backgr...

Hi, Looking for a freelancer who take a site visit and confirm about the site, Just a site visit project and check address validation, ongoing work in future, further discus about task after freelancer response. more information will be provided to the selected freelancer.

I screwed up on the backend of my website. The site is I must have clicked something that removed all the links to the socials on the sign up page. I...sign up page. I need for someone to do the following: 1. Put the logos back up (it should just be a click of a button. I just don't know which one) 2. I'd like to add two more social link to the list. (patreon & buy me a coffee) 3. I'd like for each person who signs up to get an email thanking them for joining. 4. I'd like to make it so people can't sign up multiple times with the same email address. 5. On wordpress there are numbers for each person who signs up. If I delete a person the numbers don't change order. It would be nice if they did. This isn't a major thing if hard to do th...

...WordPress website. This is exacerbated by high server resource usage and poor caching and optimization. More worryingly, I'm dealing with an excessively large Document Object Model (DOM) that further hinders the performance of my site. However, I'm unable to pinpoint specific issues caused by this. I require a skilled professional with in-depth knowledge of WordPress performance optimization to address these problems. The right person should be able to streamline my site for faster loading speed and lower server resource usage. They should also have experience in proper site caching and optimization, and have technical know-how to handle DOM size reduction and enhancements, making the site more efficient overall. Key Skills: - Expertise in DOM size reduction. I am n...

I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the website will provide common real estate features such as property searches, property listings, and a contact form. Moreover, the website would ideally cater to a range of purposes, from displaying property listings to generating leads and providing company information. Ideal Skills and Experience: - Proficiency in web development with React - Past experience in real estate website creation - Understanding of lead generation mechanisms - Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate websites ...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I'm in search of a Photoshop expert who can give the classic poster of National Lampoon's Christmas Vacation a modern twist. The core task involves replacing the faces of the characters with 7 new...possible. Key Requirements: - Expertise in Photoshop with a strong portfolio of similar projects - Ability to create high-quality, realistic face swaps - Experience with detailed photo manipulation - Proficiency in editing text on images Text Modifications: The text changes on the poster are focused on: - Replacing the movie title - Altering the tagline and credits It is essential that the final result is polished, professional, and aligns with the original style of the poster. Please only apply if you have the necessary skills and experience to deliver a high-quality, real...

I'm seeking a skilled graphic designer to create a compelling logo plus brand images for Tax Café. We like the idea of having a cup of steaming coffee, with the steam in the shape of a dollar sign. Our web address is www.thetaxcafe.ca. Tax Café is a tax filing service for Canadians. Customers will enter a warm, relaxing atmosphere where they will receive professional tax filing over a chat and coffee. Our slogan is "Relax. It's just tax." Key Requirements: - Utilize color theory to help embody the emotions we want to convey. - Design should exude a sense of relaxation so people expect a spa-like interior. - It should also convey the spirit of professionalism, competence, and hard work. - Ensure the logo appears professional and suited to the ta...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enh...

Hi, Looking for a freelancer who take site visit and confirm about site, Just a site visit project and check address validation, ongoing work in future, further discus about task after freelancer response. more information will be provided to the selected freelancer.

Hi, Looking for a freelancer who take a site visit and confirm about a site, Just a site visit project and check address validation, ongoing work in future, further discus about task after freelancer response. more information will be provided to the selected freelancer.

We need to create a web-page for an FX Currency Exchange. Its very comfort because we dont have to link any API or use a hard coding skills. We need the project have very good visuals looking for atract clients. All its made via WORDPRESS We going to bring admins acces to the wordpress project to let the editors make any change as they want. Remember the base of the project has to be the same as the websites examples.. Some examples:

I'm in need of a professional who can help me address a micro cracking issue in the flooring and ceiling of two rooms. The current materials in place are wood, which is susceptible to these problems. Key Deliverables: - Identify and rectify micro cracking in the wood flooring and ceiling of two rooms - Implement solutions to eliminate the sound of micro cracking - Ensure the materials' strength and durability are improved Ideal Skills: - Proficiency in woodwork and floor repair - Experience in addressing micro cracking issues - Understanding of soundproofing techniques The objective is to restore these living spaces to their former glory, removing the annoying sound of micro cracking while enhancing the strength and durability of the materials. A keen eye for detail an...

I'm in need of an experienced web designer to overhaul my website's outdated look and slow loading speed, while keeping it professional and authoritative. Key Requirements: - Address the outdated design by implementing modern and sleek design elements. - Optimize the site for faster loading speed. - Maintain a professional and authoritative look, aligning with my brand's personality. Ideal Skills: - Proven experience in redesigning websites with a focus on improving brand awareness. - Strong web design skills, with a keen eye for modern and sleek design elements. - Proficiency in optimizing websites for faster loading speed. Please include samples of your previous work in your proposal. I look forward to working with a talented designer who can transform my website...

...is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...

I'm seeking a seasoned C++ programmer who can design an array-based heap effectively. The purpose of this project is to handle both max heap and min heap. Here are my specifications: - Implementation of the max heap and min heap within the same array-based heap structure. - The software should be able to execute both Insertion and Deletion operations. - It should facilitate Heapify operation, enabling the optimization of the heap structure. If you possess extensive knowledge and experience in heap data structures and can proficiently utilize this in C++, you are the right fit for this task.

...interface for capturing images. It is crucial that the app also includes a secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of a passenger's landing, and store it for the driver to ensure the accuracy of the pick-up time. The skills required for this job include: - Strong experience in app development, particularly in location-based services. - Proficiency in integrating GPS services, date and time functions, and camera functionalities. - An understanding of flight tracking systems and their integration into applications. As the user interface is of paramount importance, I'm looking for someone who can create an engaging and intuitive design. Your previous experience and expertise in this area w...

Mail ..."Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/delete a new entry to a existing "inbound windows firewall rule" with the hacker's IP for a specific period of time. A good example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempts – No need to restart the service when we change settings – Highly configurable, ban anything that comes through ...

As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...

I am in need of a skillful audio engineer who can do a high-quality job in removing background noise and isolating the dialogue on an audio file. This task will specifically target an MP3 file. To produce a top-tier result, it is crucial that the freelancer assigned to this project has a wealth of experience dealing with similar ventures in the past. Proficiency showcased in their previous assignments would be indicative of their capability to fulfill this job. This is what I am looking for in my ideal freelancer: - Extensive experience in noise reduction and dialogue isolation - Capable of working efficiently with MP3 formatted files - High attention to detail - Ability to deliver the project in a timely manner If you can meet these requirements, I'd be glad to hear from...

I'm looking to fix a personal work photograph. I would like it to be cleaned up and restored as soon as possible. It's my only picture from an important professio...candidates should show past work in photo restoration or related fields. - Experience in Photoshop or similarly robust image editing software is expected. - Freelancers are encouraged to use creative yet realistic editing techniques to maintain the authenticity of the image. - The project primarily involves repairing scratches and fading but may also include color correction if necessary. - The end result should be a high-resolution digital file. This one-time project could lead to future work for the right freelancer with a demonstrated capacity for attentive detail, timely delivery, and extraordinary photo e...

I'm looking for an experienced web developer to help me create a user area website. The functionalities of this platform should include: - Account Registration: The website must have an account registration feature that requires users to provide their email address, username and password to create their accounts. User data, - Users must verify themselves with documents (kyc) I don't want to use an external system like sumup, only internally, it's easy to verify documents, photo front back and selfie - the admin can create orders and generally activate them for all users or only for individual users - the user can accept orders and then has to rate them - excites have a value that should be displayed in the backend - If users have successfully completed orders, they w...

As a gift basket business owner, I'm seeking an experienced Woo-commerce developer who can resolve a shipping issue on my website. The problem lies with the incorrect calculation of delivery fees if the customer's billing and shipping address differ. - The Requirement: I need the system to accurately use both the billing and shipping addresses when determining the delivery fee. The rates must differ based on the zip codes entered. - Essential Skills: Deep understanding of Woo-Commerce, PHP, Javascript, and any other relevant programming language. Prior experience in handling shipping/delivery rates customization is a plus. In your proposal, please discuss your previous similar projects and your chosen approach to handle this task.

...We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected status of groups that are joined or already joined. For unjoined groups that we have searched for, you can auto join. - Can Auto Post to Facebook Group Each feature has A...

...experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...

ONLY RESPONSES THAT ADDRESS THE QUESTION AT the END WILL BE CONSIDERED? I need a knowledgeable Stratum v2 expert for assistance with the following tasks: - Mining Pool Configuration: Proper setup and configuration of the mining pool. - Mining Software Integration: Seamless integration of mining software into the current setup. - Protocol Optimization: Optimization of the Stratum v2 protocol to ensure peak mining performance. The specific programming languages used for the current implementation are unknown as the previous question was skipped. In terms of hardware, my setup currently includes Windows and GPU. Thus, the successful freelancer should have experience working with these specifications and will consider this in the implementation process. The ideal freelancer shoul...

I'm in need of a skillful API expert who can complete the creation of my app on Zapier. I've already managed the authorization part; now what's required is the trigger setup. I have comprehensive API guides at hand and simply need someone with the right expertise to get the trigger implemented. Key ...involve gathering and adding the following information: - Name - Email - Phone number I'm seeking a professional with the following skills: - Strong experience in developing APIs - Proficiency in working with Zapier and creating triggers - Excellent attention to detail to ensure the trigger is correctly implemented - Effective communication skills to understand API guides and deliver the desired result Once this is done the lilypostbox app will want oushing live ...

I'm looking for a skilled professional who can assist with my existing Squarespace website and Mailchimp setup. Your primary responsibilities are To create a subscription form that is already designed you are going to make the same design in Squarespace, and then integrate that form with Mailchimp. The form is straightforward just the Email address and subscribe button. See the attached form. Key responsibilities: - Implementing design changes on my existing Squarespace website. - Effectively integrating Squarespace with Mailchimp, ensuring both platforms work in harmony Ideal Skills and Experience: - Proven experience in Squarespace website design and customization - Strong understanding of and experience with Mailchimp - Experience in integrating Squarespace and Mailchi...

Need a solution A barcode app to print and track our inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Size/Expiry/Selling PriceA/X/X/X/X/X/XX/XX/XXXX/XXXXXX.00Item description must print on the lable More details: We wish to use this app to count our inventory using bar code scanners Also when items are placed in a box to transfer between two shops, we need it to be able to use the scanner and count accuracy. Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP

I'm looking to develop an online payment website that will support transactions made using credit cards and bank transfers. The payment process should include collecting the following user information: - Name - Email address - Phone number - ID verification The ideal site should be compatible with desktop computers, mobile devices, and tablets. I need an experienced developer who is familiar with payment gateway integration and security protocols. Experience with ID verification processes would be a plus. As reference, the website should be the same as - escrow.com Please list your estimated fixed price and work duration.

I'm searching for a talented artist to customize a watercolor painting. The style of the painting is yet to be determined, as I'm open to your creative input. Key Requirements: - Expertise in watercolor art - Ability to customize art according to client's needs - Creativity in suggesting and implementing painting styles - Strong communication skills to understand and address client preferences Application Guidelines: Please include a detailed project proposal in your application. This should outline: - Your experience with watercolor painting - How you plan to approach customization - Any relevant past work or portfolio showcasing your watercolor art expertise

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

...automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient data flow throughout the application. Frontend Development: Design and develop a user-friendly e-commerce...

I'm a graphic designer based in Belo Horizonte. I'm going to present a visual identity and I would like an animation of the brand being "built", about 3/5 seconds. The reference is the assembly of this Itau brand: In the brand that I am going to present, the vertices of some letters were also edited for angles and the idea would be to demonstrate this in the animation. I have a frame by frame of what I thought, but it is in this style of the camera going through the typography customization details and then zooming out the lines passing through the brand and "cutting" the points that were edited to result in the final composition. It would all be flat, just like in Itau, without gradients, without 3D. As it is the presentation of a brand tha...

...request success. While requests from CLEAN or LOW Spam Score IP addresses often pass, those from HIGH SPAM score IPs face rejection. 2. Recognition as PROXY IP: Our solution must not only allow requests to pass but also prevent them from being recognized as PROXY IPs by the recipient system. Project Objectives: 1. Effective IP Masking: Develop a solution that effectively conceals our original IP address during requests. 2. Anonymity and Privacy: Ensure that our requests remain confidential and protect our identity. Additional Considerations: • : We are aware of tools like that can identify real user IPs versus PROXY IPs. Our solution should withstand such scrutiny. If you have expertise in this domain and can provide a solution meeting these criteria, we invite

Physical testing is to automated where test paper to be conducted online on computer lab. a Software is to be required for this purpose which has following functionality : 1. Preparation of Question bank (MCQ as well as descriptive.) 2. Preparation of Question paper based on question bank (questions to be selected randomly according to the weightage, level of difficulty etc.) 3. Showing result of MCQ part. 4. result preparation etc.

...comprehensive solution for organizing and managing computer-based tests. Key Features Needed: - User Registration and Login: The software should allow for the creation and management of user accounts. - Question Bank Management: It needs to support the management of a database of test questions. - Test Scheduling and Timer: The software should also provide scheduling for tests and a timer feature for exam sessions. - Setting of Question Paper: The system should have a feature to set up question papers for each test. - Intuitive GUI for Examinee: A user-friendly graphical interface for test takers. - GUI for Result Preparation: Additionally, a graphical interface for staff to prepare and analyze results. Platform Compatibility: - Based on client-server architecture...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on ...

I am seeking an experienced developer to create a website scraper which is capable of collecting various pieces of data. This savvy tool must be designed to extract from () site: - Text content - Images - Product information - Address - Contact details - Videos It is essential for the scraper to perform its task on a daily basis. Yet, there won't be a need for the gathered data to be automatically integrated into a database. Ideal Skills: - Web scraping - Developing scraping bots - Programming knowledge - Manual data mining expertise Please only apply for this job if you have significant experience in creating web scrapers. This project requires a quick turnaround, so the ability to work under time constraints is key. Let's converse about specifications, and develop t...

Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pag...

I'm seeking a freelancer to assist me with entry-level data entry tasks in the comforts of my home. Key Responsibilities: - Handling simple data entry tasks. - Ensuring accuracy and attention to detail. Ideal Skills: - Basic understanding of data entry procedures and systems. - Familiarity with spreadsheets and online forms. - Excellent typing skills. Experience: - While I require a beginner level of experience, any past exposure to data entry tasks will be considered beneficial. Submission: - Your tasks will be submitted via email, so a good grasp of communication through this medium is important. This opportunity would be perfect for someone who's looking for an entry-level data entry role that can be completed from home.

I'm looking for a talented graphic designer to create a flyer for a training workshop. The event is scheduled for tomorrow and will be held in Orlando, FL. Requirements: - The flyer should be simple, clear and professional - Please include the address and Google Map link - Your design should be suitable for a professional audience - No specific color or theme is required Ideal Skills: - Graphic Design - Adobe Photoshop - Understanding of professional design standards Please bid if you are available to turn this around swiftly. Thank you.

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

Deliver the fixed audio recording using the best technical software to achieve the best result

I have a website which requires a better pagespeed score. Right now its on 30 score for mobile and 60 for desktop. I want this to be 100 for both. Need someone that can do this with me either by modifying the website page or with plugins. I have some plugins installed but could not increase the score. Link will be shared in a seperate chat