How to merge two excel sheets based on one column vlookupроботи
Табличка буде використовуватись для аналізу конкурентів ринку. Вона має бути зручною для ведення, зі зрозумілим звітом у вигляді графіків на основному дашборді. Показників в різних категоріях які вона має рахувати більше 30, терміни, фінанси, порівняння, відсотки, категорії, середні значення. Чекаю Ваших пропозицій стосовно вартості
Мета: Професійне візуалізування квартири площею 71 квадратний метр із двома кімнатами, збільшення реалізму та якості порівняно з існуючою моєю роботою. Поточний стан: Одна кімната вже була візуалізована з матеріалами та освітленням. Однак, бажається більш реалістичне та високоякісне оформлення. Для довідки надано зразок цієї кімнати (мій зразок дитячої кімнати1 та мій зразок дитячої кімнати2) Додаткові довідкові матеріали включають фотографію іншої кімнати (бажаний рівень якості) та фактичну кімнату і основний файл ( та Sketchup+Vray+5+Interior+) Оригінальний файл SketchUp (квартира) буде доступний під час співбесіди. Вимоги: Коригування матеріалів: Детально налаштувати всі матеріали. Наразі я використовую V-Ray 6. Скріншоти всіхваших налаштувань V-Ray потрібно надати. Налаштування осв...
Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.
Робимо апгрейд цього проєкту: Проєкт на Ruby on Rails готовий на 70%. Необхідно: - інтегрувати платіжну систему (Liqpay); - доробити бізнес-логіку (додати момент обов'язкової реєстрації, платежу); - виправити дрібні помилки (правильна логіка для логіну/реєстрації користувача, збереження документів, скачування документів та інше). У випадку якісної роботи розглядаємо можливості постійної співпраці та підтримки проєкту.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm on the lookout for a talented and trustworthy virtual assistant based in Lesotho to assist me for a month. It's crucial to note that I expect the assistant to be physically present in Lesotho; VPN usage is not allowed due to security reasons. Tasks: - Data Entry: You will be required to handle data entry tasks efficiently and accurately. - Social Media Management: I need assistance in managing my social media accounts, including content posting and engaging with my audience. - Account Management: You will handle various aspects of account management, which will require attention to detail and a proactive approach. Duration and Hours: - The project duration is one month. - I expect you to work less than ...
...project requires an experienced programmer who has the technical abilities to modify an XSL style sheet and adjust its layout. The task will specifically focus on: - Changing the layout of the style sheet and VB code. This modification is needed to appropriately accommodate some new fields that have been added to an import file. - Improving the style sheet so as to automatically map the new fields from the import file. The ideal candidate for this job should have experience with layout adjustments in XSL style sheets, automatic mapping of new fields and VB coding. Your skills and experience in rearranging content layout, updating fonts & colors, and altering data display formats will be highly appreciated. Don't hesitate to ...
...building project that requires an experienced structural engineer. Your primary task would be to evaluate the necessity of central RC columns in the building by checking the load distribution from the provided load calculation sheets. Key responsibilities: - Evaluate the need for central RC columns in a multi-story building - Thoroughly analyze the provided load calculation sheets for structural integrity - Provide alternative design solutions if necessary Ideal skills for this job would include: - Professional experience in structural engineering, especially for multi-story buildings - Expertise in evaluating load distribution and structural integrity - Ability to provide alternative design solutions based on your analysis Your work will gre...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Abil...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financial management together.
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
...virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing strategies to improve CRM processes and efficiency. Customer Service: Respond to customer inquiries and resolve issues promptly and professionally. Maintain a high level of customer satisfaction through effective communication and problem-solving skills. Liaise with other departments to ensure customer needs are met. Email Management: Monitor and manage the CEO's email inbox, prioritizing and flagging important messages. Draft, p...
I'm in need of two captivating, text-based logos. Key Requirements: - The first logo will represent an advertising agency called AD ADDICT COMMUNICATION. This logo should be designed to be text-based, but with a creative touch. - The second logo is for an online classified ad portal known as POST YOUR This one should also be text-based and visually engaging. Specifics: - Both logos are to be in pastel shades, so the ability to work with this color palette is essential. - You won't need to incorporate an emblem or a specific symbol subtly within the text for either logo. Ideal Freelancer: - A skilled and experienced logo designer with a strong portfolio showcasing previous work, particularly in text-based l...
Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Winner with real amazing design will get a nice bonus, contest prize is just so low cause I have to pick a winner right away I am looking for a skilled UI/UX designer to create a minimalist and clean interface for a new iOS application. The design will need to be optimized for both iPhone and iPad and android phones/ Key Requirements: - Prior experience designing iOS apps, particularly with a minimalist aesthetic. - A strong understanding of UI/UX principles and best practices. - Able to create designs that are visually appealing and user-friendly across different iOS devices. - Experience with prototyping tools such as Figma, Sketch, or Adobe XD would be a plus. - Availability for discussions regarding the project vision and implementation. - The design shou...
...skills to complete easy chores. Responsibilities include having regular discussions across multiple dating platforms. The final goal is to quietly shift folks from dating applications to Instagram chat or Snapchat app. This gig runs on a per commission basis and will cost $5. My virtual assistant can close an appointment in 15 minutes or less. I'd imagine. Some minor fluff discussion is required. One out of every five leads to a sale in less time. So, for now, I'll put the fee at $5. A minimum of $200 to $300 a month can be earned from your phone. only working one hour or less per day I'll be delivering two canned lines. You simply use it multiple times, but you can customize it to suit your prefere...
i am looking for one website with alomost 25-30 pages using nextjs technology as platform. the design will need to be added with tailwind css , nextjs and nodejs based Content management system where we able to manage and edit or add new contents as and when required. if anyone having ready to use cms platform for nextjs with nodejs along with good team for the web design they can provide there details of projects. the design inspiration and content inspiration will be from we will need similar design and flow as showing in this site with same contents.
I'm seeking a highly skilled digital advertising contractor to manage and drive a targeted campaign on social media and via email marketing. The successful applicant should have: - A proven track record in digital advertising, specifically in social media platforms and email marketing. - An understanding and ability to successfully target business professionals. - Tactical skills at creating and managing effective, results-driven advertising campaigns. This job is ideal for professionals who are adept at developing captivating advertising campaigns that resonate with a business-focused audience. They should also excel in consumer profiling and targeted content presentation. I look forward to hearing from you!
I'm looking for a freelancer to conduct market research to determine the best selling aftermarket products in the motorcycle industry: specifically, my target segments are in the super sport, sport, sport touring and cruiser Japanese motorcycles (Honda, Suzuki, Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would include Amazon and Ebay but open to other possibilities too). I wanted to limit the types of products to: (1) Brackets (2) Protective engine covers (3) Levers (brake, clutch, etc..) (4) Air intake components (air intake box or air inlet ductings). The project consists of 2 parts and thinking it would be in Excel format (but open to other formats too):
I'm looking for a skilled video editor who is proficient in Canva to help me complete a 1 hour 7 minutes Canva video. 17 minutes have been created. We need to follow the same formatting / style to complete the video. We add slides (use the templates we already used) and video and some animation elements to make it look good. The voice over has been fully uploaded so the slides, video clips just need to correlate with the provided audio. Key Requirements: - Length: The final video should be 1 hour 7 minutes long. I need someone who can ensure the pacing and flow of this length is maintained. (50 minutes remaining - no modifications on existing 17 minutes) The main message of the video is to educate and inform the viewers. It is essenti...
I have a website. Need one page change dynamic from static. I have an admin panel also need control that page from admin panel. Also need a new user for admin panel with some limits. For example new user should edit only news section. Database is on postgresql.
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I'm looking for an expert in on-page SEO who can help me increase my website traffic. - I'm interested in SEO strategies that focus on optimizing the content and structure of my website, so that it ranks higher in search engines. - Your main goal in this project is to drive more organic traffic to my website. Your role would be to: - Conduct a detailed analysis of my website to identify areas of improvement for on-page SEO - Implement strategies that improve the website's visibility and ranking on search engines - Monitor, measure and report on the impact of these strategies on website traffic Skills and experience required: - Proven track record of successful on-page SEO projects - Strong ...
...a creative, professional web designer who is experienced in Shopify. The project is to create a unique E-commerce website with a variety of specific features. Key Requirements: - Integration of Payment Gateways: This will be a fully functioning E-commerce website, so it's crucial that it supports a variety of payment methods. - Customer Reviews: The site should allow users to leave reviews and these reviews should be incentivized - users should earn credit when they write a review or share their experience on Instagram. - Inventory Management: I need a system that allows me to easily manage inventory and stock. - User Photo Upload: I want to enable users to upload their own photos at a specific segment on the website. - Internationa...
...We are currently seeking a dynamic and motivated freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for helping others access essential healthcare services. Responsibilities: -Make outbound cold calls to potential prospects to prequalify them for our no-cost health benefits program. -Conduct approximately 100-200 calls per day with a focus on efficiency and effectiveness. -Engage prospects in a professional and empathetic manner to gather necessary information. -Use qualifying questions to determine eligibility based on income le...
Seeking an SEP expert using Yoast Premium SEO with a good command over the English language to optimize my WordPress hosted websites. Here are the links to the websites
I am seeking an RPA Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the ...
I'm in need of an experienced developer capable of creating an innovative app that will significantly impact waste management. The primary goal of this project is to optimize waste management by utilizing satellite imagery to identify dumpsites in real-time. Key Features: - Real-time Satellite Imagery: The app will need to incorporate this feature to collect the most up-to-date data. - GPS Location Tagging: Each dumpsite identified must be accurately pinpointed using GPS for easy tracking. - Dumpsite Detection Algorithm: A robust algorithm is needed to analyze the satellite images and efficiently identify dumpsites. User Base: The primary users of the app will be government agencies, so the interface must be user-friendly and intuitive. I...
...skilled software developer to help create a comprehensive property management system tailored for web-based operation. Key Functionalities: - Rent Collection: The software should have a streamlined rent collection system to facilitate regular and efficient payments. - Tenant Communication: A robust communication platform is crucial for maintaining a smooth landlord-tenant relationship. The software should include features that enable swift and secure communication. - Maintenance Tracking: A maintenance tracking system is essential for both tenants and property managers. I would like the software to have a feature that tracks and manages maintenance requests. Platform and User Role Requirements: - Platforms: The ideal candidate should be proficient in web-...
I have a Contabo VPS with Linux OS that I need to be set up with Cloudpanel and properly configured on an urgent basis. Key Requirements: - Set up Cloudpanel on a Contabo VPS with Linux OS - Complete configuration and installation of Cloudpanel - Ensure the server is ready for immediate usage upon completion - Tighten security and optimize performance I am looking for an experienced server administrator with the following skills: - Proficient in setting up and configuring cloud server environments - In-depth knowledge of Linux operating systems, particularly CentOS - Familiarity with Cloudpanel or similar server management panels - Ability to work quickly and efficiently, meeting tight deadlines This is an urgent task, so I need someone who can start immedia...
I’m hosting a contest for the recording hand gestures on video. We will be selecting multiple winners. If you are proficient with ASL (American Sign Language) this will be easy for you. $25 per approved ASL video ASL knowledge is preferred but not required. Some gestures are unique and NOT part of ASL. We have a spreadsheet with a list of gestures and an example video that you can use as a reference. The end result of the entries will be used to train a machine learning system. Requirements -recording must be .mp4 format -Gestures must be recorded in a well lighted area. -You must have a solid color shirt on... no patterns. -You must do the gestures in the order they appear in the spreadsheet -Each gesture you do, you must speak the name of the gestu...
Looking for someone to create 3D visuals of houses based on a plot image. Need one picture of a standalone house and one of a house joined to another. Both should have a place to park a car and a garden. Make them look real, like you're standing outside.
Hey, I'm currently developing a token on Solana called Kosher Token. Once that is complete, I would like to develop an app. I would like to get a quote for developing an app with you. The app will need to run on mobile (apk) and desktop (cloud). The MVP will include two products: the Kosher Wallet and Kosher Vendor. Need a quote for each product respectively. Please see UI design attached for reference. (Desktop and mobile versions will be very similar. We do not need two completely different designs) The landing page is already done: I only need a quote for the app. Please review the documents attached and ask any relevant questions you may have. Then please send me a rough estimate and timeline. I ignore all auto bids. I only engag...
We are an Ecommerce ...company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Ha...
Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!
Basically we are dealers in computers and cctv cameras I am looking for a website, only one messaging bar center of website once client sent message from that message, the same I have to receive on my whatsapp message and then we can continue chat in whatsapp only, basiclly I want my clients to forward to whatsapp chat and a nice bakcground image of all computers parts and cctv parts image One logo of my company name with images of computers brand
I'm looking for a skilled developer to create a smartphone application that will serve as a tour guide for travel groups. Key Features: - It should be compatible with both iOS and Android devices. - The primary feature should be the ability for a tour guide to speak to the clients in real-time, providing live, interactive commentary throughout the tour. - The app should support live chat for clients to ask questions to the tour guide. - Smartphone-based tour guide system: One simple app for both speaker and listeners. Works on any device that is connected to the internet via WIFI or mobile data like 3G, 4G or 5G. Ideal Candidate: - Proficient with app development for both iOS and Android. - Experienced in integrating re...
I'm looking for a freelancer who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple busin...
I'm in need of an experienced graphic designer to create a captivating, illustrative logo that stands out and reflects the essence of my brand. This design is crucial for my upcoming product launch, and I'm working on a tight deadline. **Ideal Skills and Experience:** - Strong portfolio in illustrative logo design - Ability to translate concepts into visual designs - Proficiency in Adobe Illustrator and Photoshop - Great communication skills and ability to work under tight deadlines **Requirements:** - Design a unique, illustrative logo that embodies my brand's values and essence. - The final logo must be scalable, as its primary use has not been defined yet; it could range from web applications to print materials or product packaging. - ...
...search of a competent female operations support assistant to aid me in daily tasks. Key Responsibilities: - Spreadsheet Management: You will be tasked with keeping our Excel sheets organized and updated to ensure seamless operations. - Report Generation: You will also be responsible for generating reports for our activities. These reports must be clear, concise, and error-free. - Daily Calls: You will make regular teams calls within the operations team. - Research & Analysis: The role will also require you to conduct research and analysis on various topics as needed. Your Excel Skills: I need a candidate who is proficient in Excel. An intermediate level of understanding and experience in Excel is a requirement for th...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We are an Ecommerce ...company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Ha...
...specifically on portrait work, even in scenarios with messy hair. The final goal is to invert the mask to be able to work on the background. I would love to have a visual representation of the Photoshop panels included. Here are some of the specific requirements: - Techniques and tools should focus on Quick Selection tool, Refine Edge tool, and Refine Hair - Each step of the process must be clearly explained. Step-by-step written instructions with supportive visuals preferred. - All information must be concisely formed into a PDF document to be both user-friendly and convenient Freelancers with advanced proficiency in Photoshop, excellent tutorial formation, and instructional design are highly valued. Previous experience in crea...
...list of 10,000 names and email addresses in a Google Sheets document. Your job will be to: 1) verify these contacts by checking if they are still active on LinkedIn, and if so, 2) determine where they are currently employed. 3) Do a test email and verify if the email address is currently active 4) Replace an inactive email with a new active email address Key Requirements: - Experience with LinkedIn verification - Strong organizational skills to handle 10,000 contacts - Expertise in using Google Sheets - Ability to cross-check large volumes of data swiftly - Attention to detail to ensure accuracy Deliverables: - A revised Google Sheets document with active contacts' current employers listed Timeframe: - I'm look...
More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.
