Excel formula help need onetomany vlookup type of formulapekerjaan

I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are pos...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

As the owner of , I require a skilled technical expert to significantly enhance the speed of my website on both desktop and mobile platforms. Importantly, the end result should surpass a speed score of 95. - The type of optimization (Frontend, Backend, or Both) is at the discretion of the skilled freelancer, as I've not specified this area. - I have not yet identified specific issues contributing to my website's speed, so a comprehensive analysis will be necessary. - Knowledge of backend access will be of great value, as I've not mentioned it. Ideal candidates should have: 1. Expertise in website speed optimization 2. Proficiency in undertaking comprehensive website audits 3. Experience in backend structures if requi...

... Short concept details: We own a 115.000 sqm land together with around 10.000 sqm already built surfaces (hotel, restaurant, SPA, bistro, gym, indoor cinema, etc.). The concept of our complex is based on the idea of complementarity. The focus of the business will be permanently oriented towards offering our guests high-quality services, as we all want. At the same time, our focus will be on attracting as many guests as possible from among children between the ages of 3-4 and up to the age of 14-15 and even high school students. This objective of ours would mean the main source and also the most important source of income. The complex will include functions and activities intended for both children and adults. During the summer holidays (...

...identify and target college graduates, job seekers, and professionals across industries such as IT, sales and marketing, finance, and accounting. - Craft persuasive pitches to showcase the value of our 30-minute mock interview sessions in preparing candidates for specific job roles. - Implement strategic sales tactics to exceed targets and maximize earnings potential. - Build and maintain relationships with clients to ensure satisfaction and drive repeat business. **Ideal Skills:** - Proven track record in freelance sales, with a portfolio of successful projects and satisfied clients. - Deep understanding of the IT, sales, marketing, finance, and accounting industries, including common interview practices and requirements. - Outstanding communication and interpers...

...identify and target college graduates, job seekers, and professionals across industries such as IT, sales and marketing, finance, and accounting. - Craft persuasive pitches to showcase the value of our 30-minute mock interview sessions in preparing candidates for specific job roles. - Implement strategic sales tactics to exceed targets and maximize earnings potential. - Build and maintain relationships with clients to ensure satisfaction and drive repeat business. **Ideal Skills:** - Proven track record in freelance sales, with a portfolio of successful projects and satisfied clients. - Deep understanding of the IT, sales, marketing, finance, and accounting industries, including common interview practices and requirements. - Outstanding communication and interpers...

I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if y...

I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to under...

I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliv...

I'm seeking a detailed market research report on the baby milk formula industry in India. The report should cover: - Market size and growth trends nationwide - An in-depth analysis of the competitive landscape including market share - An overview on consumer preferences and purchasing behavior The main objective of this market research is to assess the competitive landscape of the baby milk formula industry in India, enabling me to make informed business decisions. A nationwide, Pan-India focus is required. It would greatly benefit from having a candidate with experience in market research, an understanding of the Indian consumer market—especially the baby product segment—and excellent analytical skills.

I urgently require a freelancer to create a logistics management system for my busines...inventory. Key Points: - The system should be able to efficiently track shipments and provide real-time updates. This is crucial to improve our customer service and overall business operations. - The inventory management module should be effective and user-friendly. As a business with 18 warehouses, we need to ensure all stock levels are accurately and efficiently maintained across all locations. Skills and Experience: - Proficiency in logistics software development - Strong understanding of inventory management systems - Prior experience with large warehouse networks - Ability to deliver a quick and reliable solution is a must NOTE : My budget is only $100 because it's only for s...

so i have selfhosted this and i need something like this in between u just need to change style/css of radio form to look something like that package image

Seeking a talented VFX designer to create captivating visual effects for a video. While the exact type of effects required was not specified, we are open to suggestions and highly encourage creative input. Key responsibilities: - Develop high-quality VFX for a video project - Collaborate with our team to understand project scope and objectives - Make necessary revisions based on team feedback Ideal skills: - Experience with various VFX software (After Effects, Cinema 4D, etc.) - Strong understanding of animation, timing, and pacing - Flexible and open to varied artistic directions Note: While the style/theme for the VFX hasn't been defined, we are eager to see your unique artistic approach to our project.

Seeking App developer for my Candy Game app Project.

...modern and minimalistic combination of text and icon logo for our business. Additionally, I will need these graphics animated. Key project details include: - Logo Style: Modern and Minimalistic - Logo Type: Combination of text and icon - Animation: Both logo and icons - Deliverables: High-quality, engaging animations Ideal skills and experience for this job include: - Proven expertise in graphic design, particularly in creating modern and minimalistic logos - Proficiency in animation, with a strong portfolio of previous work - Ability to effectively convey brand messaging through design - Strong communication skills and a keen eye for detail If you're a creative professional who can bring my vision to life, I'd love to hear from you. Ple...

I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.

I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching

I'm in need of a skilled professional to create a No-Code app on the Adilo platform or any other. It shall has three interface. 1. User Interface 2. Management Interface 3. Service Provider Interface App Idea: Chat based profile matching for Carpenters to work on hourly basis. User Interface Step 01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Profesion...

I'm looking to build a live dashboard that will display the results of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so...

... OR SOME OTHER MARKETING. I POSTED THIS PROJECT LOOKING FOR PEOPLE THAT HAVE THIS TYPE OF LISTS, AND ALSO FOR BROKERS THAT HAVE ACCESS TO THESE TYPES OF LISTS. I'm in need of lists of Real Estate Investors and Real Estate Owners from UAE (Dubai specifically), (or) the entire Gulf region, (or) UK, for a targeted marketing campaign. Key Requirements: - Detailed Lists: This should include the names, contact details, and investment preferences of the individuals. - Specific Criteria: The potential leads should be based on specific location and property types. I'm looking for an expert who can provide high-quality and comprehensive lists of Real Estate Investors and Real Estate Owners in each of these ...

I need a PHP site that includes a straightforward yet robust admin panel. To fit my specific needs, it should have: 1. All Page Dynamics 2. App Listing with article editor 3. App Type Listing Like Top Trending, New Apps, Fraud Apps with Admin Panel Option. 4. Home Page Slider With Link. 5. Top 3 App Choose Option or Pin Option. 6. Home Page Notice Edit Option 7. Load More Options Apps Category. 8. Home Page FAQ Options. 9. Side Social Media Options. 10. Categories Create Option and Select. 11. Trending Page + High View Post. 12. Search Home Page Option. 13. Footer Ads + Link Option. 14. Google Ads Option Manual and Auto. 15. App Listing: App link, Banner+Js Copy+FAQ+Footer Marquee Text 16. Brand Logo Change+ WhatsApp Link 17. Full Analytics All Website Like Every Days, Month...

I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include specific da...

I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 10-15 minute ti...

I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.

I need someone with meticulous attention to detail to manually type the text from a PDF file into Word while applying a new format. Your task will involve: - Reading the text in the PDF file and typing it in a Word document. - Applying a totally new formatting scheme that I'll provide. - Ensuring that the text still makes sense after the reformatting. The ideal person for this job should have: - Strong typing skills. - Familiarity with Word formatting tools. - A keen eye for detail to ensure that everything is copied accurately. - The ability to reformat the text in an organized and pleasant way. The purpose of this task is to both edit the content of the file and extract specific information, so your ability to stay on task is essential.

Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up dat...

I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and a...

I'm seeking a proficient typist to carry out a data entry project in English. The ideal candidate will seamlessly enter textual data ensuring its accuracy and completeness. - PRIMARY PURPOSE: Data entry - LANGUAGE SPECIFICATIONS: Must be proficient in English - DATA ENTRY TYPE: Textual With a keen eye for detail and quick typing speed, the appointed candidate will significantly contribute to the project's successful completion. Previous experience in similar roles is preferred.

I'm in need of someone who can help with an image compression and webp project. I'm looking for someone who is a fast worker and is experienced in this type of task. Key Requirements: - Proficiency in image compression techniques and tools - Experience with WebP format and optimization - Ability to deliver fast and efficient work Please let me know if you're interested and if you have any prior experience with similar projects.

...for cotton fabric. This design will be used on clothing, so it needs to be versatile and suitable for different types of apparel. Key requirements: - Expertise in print design: I'm looking for someone with a strong background in textile print design, particularly for clothing - Design skills: The print should be able to be used in any way the pattern is cut, we would like it to be seamless and slightly "vintage/blurry" feel to it (almost like a watercolour effect) with a mix of different design elements to it (perhaps some florals, peacocks or seashells etc mixed together.) Can take some inspiration from vintage Indian block print fabrics but not too much. - Understanding of clothing design: It's important that the design is suitable to be cut i...

I’m looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure your bid reflects...

Title: Sales Representative Specializing in the Meat Industry in UAE Location: Remote, UAE Job Type: Freelance with a potential for full-time engagement Description: We are seeking an experienced Sales Representative with expertise in the Meat Industry, specifically within the UAE market. Your role will involve intensive market research and lead generation, focusing on the importation and distribution of chilled lamb from Australia, Kenya, and South Africa. Responsibilities: Conduct thorough market research to identify and analyze the prices and competitors within the UAE meat market. Identify and reach out to at least 40 potential suppliers, including wholesalers and importers, to obtain competitive quotes on chilled lamb varieties. Essential data points include: - Lam...

fixed price, not for profit, We work in real time via screen share. - Predefined donation amounts: I'd like to provide a few fixed donation options for the convenience of the donors. - Custom donation amount entry: There should be a field where donors can manually input their desired donation amount. - Recurring donation option: I want donors to be able to make monthly donations, in addition to one-time donations. The captcha system I prefer is image-based. It should be user-friendly yet effective in preventing spam and bot activity. or recaptcha3 As for the payment gateway, I am specifically looking for Moneris integration. It's crucial that the forms and transactions are secure and reliable. Ideal skills and experience: - Proficiency in web development, particula...

whell... i have a laravel dashboard, PHP 7.4 laravel 7, MYSQL, repocitory on github (private)... i need continue working on it, but my normal freelancer is bussy right now... so open vacant... Please let me know u questiongs. Br. Im prefer spanish lang for choise my freelancer, but all are whelcome...

The course link on is: /ou/course/java-se-17-programming-complete/106874

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

I need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cleaning with experience in standardizing the formatting of textual content. - The data is currently stored in plain text files, so experience working with this type of data storage is necessary.

I'm in need of a Python script that can crawl through a list of websites provided in an Excel file and export all the webpages it finds into a new Excel file. This task is aimed at scraping the entire content of the websites, not just a specific piece of information. Key Requirements: - The script must be able to read a list of websites from an Excel file. - The script should use natural crawling mechanisms, not sitemap, to find all the webpages on each website. - All the webpages found on the websites should be exported into a new Excel file. The purpose of this script is to aid in analyzing the content of these websites, so it's crucial that all pages are scraped. Ideal Skills: - Proficiency...

...algorithm, currently operating on the TradingView platform, generates precise buy and sell signals. However, we require assistance in seamlessly translating these signals into actionable trades on our trading platform. The primary objective of this project is to integrate our existing algorithm with the trading platform's API to automate the execution of trades based on generated signals. The selected freelancer will be responsible for establishing a robust connection between the algorithm and the trading platform's API, ensuring timely and accurate execution of orders. Key tasks include: 1) API Integration: Configure and establish a secure connection between the algorithm and the trading platform's API, allowing for seamless communication and trad...

Purpose The purpose of this implementation is to provide a means to connect to an IP camera over RTSP and ingest the video+audio streams using gstreamer with golang and the go-gst bindings. Once the stream is ingested we need to break-out in to children pipelines to perform various tasks such as creating HLS segments and persisting to disk for future playback and transcoding H.265 to H.264 so that the stream is compatible with the WebRTC requirement of H.264 support. Functionality The functionality demonstrated in the above diagram is broken out to: Ingest Pipeline Responsible for connecting to the IP camera over the RTSP protocol using the rtspsrc element. Once connected the pipeline needs to prepare the stream for consumption by lower pipelines as below. Segment ...

I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities...

I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.

Kami telah menyusun deskripsi proyek dari jawaban Anda. Tambahkan detail tambahan apa pun yang Anda ingin pekerja lepas ketahui sebelum melanjutkan ke langkah berikutnya Deskripsi Proyek Saya mencari seorang treelancer untuk membantu saya mengumpulkan data kuantitatif untuk penelitian akademis. Saya memiliki daftar sumber spesifik yang saya ingin datanya dikumpulkan Kemampuan dan pengalaman: - Pengeluaran dalam bentuk pengumpulan dan analisis data penelitian akademis

Kami telah menyusun deskripsi proyek dari jawaban Anda. Tambahkan detail tambahan apa pun yang Anda ingin pekerja lepas ketahui sebelum melanjutkan ke langkah berikutnya Deskripsi Proyek Saya mencari seorang treelancer untuk membantu saya mengumpulkan data kuantitatif untuk penelitian akademis. Saya memiliki daftar sumber spesifik yang saya ingin datanya dikumpulkan Kemampuan dan pengalaman: - Pengeluaran dalam bentuk pengumpulan dan analisis data penelitian akademis

I'm in need of a photographer based in Durban, South Africa. This is a freelance opportunity for a skilled professional who can capture high-quality images. Key details: - Your role will include taking photographs in Durban, South Africa, so residing in or near this location is a must. - The specific type of photography required will be discussed upon hire. Necessary skills and experience: - Proven experience as a photographer - A portfolio showcasing your work is a must - Understanding of photographic principles and techniques - Excellent communication skills - Ability to work independently and creatively. I'm looking for someone reliable, creative, and with a good understanding of photography in a commercial context. Looking for...

I have a web-app for teachers and I want to make a mobile app to access the same features on the go. I have an API ready and designs, I would like someone to make these screens (pixel perfect) as quickly as possibly) either natively or in a cross-platform framework for Android and iOS. Please take a look at the current designs in Figma: ...and give me a quote for how long it would take for you to re-create these screens, closely matching the designs, with no functionality yet, just the designs.

Seeking App developer for my Candy Game app Project.