Excel index match return multiple values in one cell työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

Updates on multiple websites.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Multiple Writing jobs.

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

Hi Rabiul! Ive got 144 images. I need to have the background and hanger removed. I need the original size and cropped to 935px x 1400px @ 72dpi (save for web)... each clothing piece should match at the shoulder width.... with grey RGB 241 background color.. Thank you so much!

...agency's () requirements in the different tabs and menus of the CRM system. The freelancer will also need to update the same content in the actual CRM system. Additionally, the freelancer must send a complete file containing all the content created for the project separately, including demo proposals. Responsibilities: 1) Collaborate with our CRM team to understand our current processes and requirements 2) Conduct thorough research and gather necessary information 3) Write detailed, step-by-step instructions and guidelines for various CRM processes 4) Ensure documentation is easy to understand and follow for both new and experienced users 5) Organize and structure the content logically for efficient reference 6) Maintain consistency in writing style, tone, an...

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic de...

I'm in need of a skilled architect or structural engineer to create a detailed pole barn design for my new garage. This will be a 30' deep by 40' wide structure with 3 overhead doors. It will be attached to my house. Per local building code I can do so as long as I use pre-cast perma columns into the ground. I want a 5/12 pitch on the roof. 10' walls, there will be steel on the roof with perlings. It will be sided so will be putting plywood or zip system on the exterior. The attached design is pretty much what I'm looking for other than I have changed to a 5/12 pitch. On the right side I need it to be a bit wider as that's the side that will be attached to the house and will need to put stairs inside for entry to the back mudroom. Key Requirem...

...need an expert in Python and Arduino (C++) code. The main task is to correct the Arduino code I already have. Currently, I am sending in string containing 80 characters or so like (<4, 100, 30, 200, 15, 100, 15, 20, 10>), from Python to arduino, however arduino is receiving 0 as the values for the ending like like (<4, 100, 30, 200, 15, 100, 0, 0, 0>). In the serial monitor it does receive the correct values. Here's what the job requires: - Review and correct the current Arduino code - Arduino MUST receive the correct values sent from Python - Adequate understanding of Python as values are sent from Python - Ability to provide suggestions for improvements would be a plus Ideal skills and experience: - Strong proficien...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

...creative and experienced graphic designer to help us refresh our existing business' brand and design a new logo to match. Key Requirements: - Logo Style: I'm particularly interested in a modern, minimalistic design that incorporates elements of blue, sunshine, popcorn, with a plain and interesting twist. This should embody the essence of our business in a sleek and current manner. - Color Scheme: The logo should predominantly feature the color blue, while ensuring the other elements are subtly incorporated. The ideal candidate will have: - Extensive experience in graphic design, particularly in brand and logo design. - A strong portfolio of modern and minimalistic designs. - Proficiency in translating business concepts into visual el...

I'm looking for a talented artist to design a realistic cover for a song that reflects global situations. The work should encapsulate these key elements: -...for a talented artist to design a realistic cover for a song that reflects global situations. The work should encapsulate these key elements: - A globe or world map - Hands reaching out - Symbol of unity or harmony I envision an image that communicates a clear message about universal love and harmony. The artwork must not only match the song's theme but also enhance its message. Ideal candidates should have: - Proficient experience in realistic artwork - Expertise in symbolism, preferably related to global unity - A keen eye for detail to create a compelling song cover Please provide a portfolio of si...

...involves changing the colors of the 3D files provided for the simulator to match the colors specified in our branding guide. The primary color will be black, and the secondary color will be green. This project requires precision, attention to detail, and adherence to our brand's color scheme. Responsibilities: -Review our branding guidelines and understand the specified color palette and design principles. Use provided 3D files of the racing simulator model to modify the color scheme according to the branding guide. -Ensure that all components of the simulator, including the frame, seat, controls, and other elements, are updated with the correct colors. -Make necessary adjustments to achieve consistency and accuracy in color representation across the entire m...

Job Description: We are seeking an experienced and creative Designer to develop a modern and sleek housing for our state-of-the-art traction loss platform used in a racing simulator. The platform is comprised of three layers: a base layer, a second layer equipped with two linear motors for left and right movement, and a top layer with a single linear motor for forward and backward movement. We have a basic frame design already established but need a designer to refine and enhance the aesthetics to match our modern and high-performance simulator systems. Responsibilities: -Design a visually appealing, modern, and sleek housing for the traction loss platform that complements the existing frame design. -Ensure that the housing facilitates easy access to the mechanical compone...

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting...

...music, character voices, and in-game sound effects. This game is being specially developed for the mobile platform. Key Responsibilities: - Develop and implement engaging background music that complements the gameplay - Create distinctive and suitable voiceovers for a small range of game characters - Design a variety of in-game sounds to heighten the player experience Ideal Skills and Experience: - Prior experience in creating audio for successful mobile games - Proficiency in using audio editing software and game development tools - Strong understanding of how sound complements gameplay - Ability to create high-quality voiceovers for multiple characters - A passion for mobile gaming and a keen ear for sound aesthetics. Please provide samples of yo...

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer shou...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsiste...

Looking for a qualified freelancer proficient in Node.js, , and PostgreSQL. While there's no specific Node.js version requirement, key functionalities needed for the backend include: - User Authentication - Data Storage and Retrieval - API Integration Ideal freelancers should have extensive experience in these areas and a firm understanding of PostgreSQL as our chosen data storage technology. Your expertise will be vital in driving the smooth operation of our project's backend. Let's connect if you're a match.

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previo...

As an author, I need professional assistance with the formatting of my book in Microsoft Word. The successful freelancer will excel in the following areas: - Expertise in formatting documents in Microsoft Word, particularly in the context of books. - Knowledgeable in setting up appropriate page layouts that will represent my content in a visually pleasing and easy to navigate manner. - The ability to create stylistically consistent and engaging chapter headings. - A keen eye for selecting and applying font styles that enhance readability and match the tone of my book. Past experience in similar book formatting projects would be considered an asset. This project consists of: -Assuring uniform layout of pages -Insert re...

I am looking to hire a professional video producer who is experienced in creating engaging videos for talk show podcasts. Ability to produce video with a single host format is a must. Key aspects of the project include: - Creating an engaging intro to set the stage for the podcast episodes - Working with transitions between various segments - Incorporating appropriate background music to match the tone and tempo of the discussions Ideal candidates would have a keen ear for music, a good sense of timing for transitions, and an eye for aesthetic visual details. Those with direct podcast video production experience would be preferred.

I require a mobile crypto wallet for my existing business. The wallet is for a coin that's a fork of lite coin. I already have a UI design in place, but I need to add more features to it. The core functionality is already set up. Key Tasks: - Develop a mobile crypto wallet for my business - Use the existing UI design as a base and build upon it - Ensure the wallet supports multiple cryptocurrencies Ideal Freelancer: - Experienced in creating mobile crypto wallets - Proficient in working with lite coin forks - Skilled in UI design and development - Capable of integrating support for multiple cryptocurrencies into the wallet - Able to work on a project for an existing business and accommodate additions to the existing design

I'm looking for someone who can bring creativity and professionalism to this project, and who is able to deliver high-quality work in a timely manner. Check attached picture as sample and provide a better design. Create a Conference Poster with the details below: AFRICA MUST THINK CONFERENCE 2024: National Heroes Stadium; 29th September, 2024, 12:00hrs to 17:30hrs Host: Dumisani L N’cube-The Radical Entrepreneur TICKETS: Standard-K100, Gold-K300 + Book, Platinum-K1000 + Books + VIP. Computicket (Across Shoprite outlets) Cell: +260 97 1782299 SELECT YOUR PREFERRED IMAGES HERE ?

...meticulous graphic designer to retrace my company's logo. This logo is currently in high quality, but I’d like it to be enhanced further. Key project parameters: - The logo should be traced to an even higher resolution, ensuring sharp details you might expect from professional logo design. - I want the color scheme to remain exactly the same as in the original. - Importantly, the logo should remain identical in all other specifications - no changes or additional elements are required. Ideal Person for this Job: - Highly proficient in graphic design software - Experience with logo design and retracing - Great attention to detail - Able to perfectly color match original logo Deliverables will include the logo file in both PNG an...

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...

...locations. The key features of the website should include: - Informational Pages: Pages dedicated to rental rates and terms, vehicle options, and location details - Booking System: An online booking system integrated with multiple payment methods. The system should be user-friendly, secure and responsive. - User Experience: A smooth and intuitive user experience is essential for our target audience, who are likely looking to rent mobility devices with ease. The ideal candidate for this project must have: - Proven experience in developing similar websites - Expertise in creating user-friendly, responsive interfaces - Knowledge of integrating secure payment gateways into websites - Strong attention to detail and excellent communication skills I'm looking for ...

...using WooCommerce. The focus of this project is the creation of a highly customized product page for our unique products. Here's what is required: - The product is custom and has multiple variables including color, size, and material type selection. The product page should allow customers to select from these options with ease. - Additionally, the product page should feature a "step-by-step configuration process". This means that the customer should be guided through the customization process in an intuitive and user-friendly manner. Ideal Skills and Experience: - Proficient in WooCommerce and prior experience in building custom product pages. - Strong understanding of ecommerce platforms and best practices. - UI/UX design experience would be...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with your expertise.

I'm in need of a logo designer to create a classic and traditional logo for my brand. The main purpose of this logo is to serve as a strong brand identifier. Key Requirements: - Classic and Traditional Style: I'm particularly interested in a logo that exudes a timeless and elegant feel. - Color Scheme: I'm open to suggestions on the color palette. Please propose a color scheme that complements the classic theme and contributes to a strong brand identity. Ideal Skills and Experience: - Proven experience in designing classic and traditional logos. - Strong design skills and a keen eye for aesthetics. - Ability to understand and incorporate brand values into the design. - Creative thinker with a good understanding of brand identity and market posi...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

I'm looking for a IoT/WSN secu...security solutions that to prevent hatchetman attack occurrence in RPL routing protocol. Ideal Skills and Experience: - In-depth understanding of RPL routing protocols, Contiki 3.0 and Cooja Simulator - Hands-on experience with 6LoWPAN wireless technology - Proven expertise in IoT/WSN solution design and implementation Key Tasks: - Implement Hatchetman attack in Contiki 3.0 - Implement Resolution of Hatchetman attack using 2ACK scheme. - Implement Countermeasure to Hatchetman Attack using Multiple Encryption - Evaluate the two solutions with each other and with the standard RPL (RFC 6550) under Hatchetman attack and the State of the Art Solution. - Detailed code documentation of the implemented solutions. Further...

I'm in need of a talented photo editor proficient in object removal from images. The primary requirement of this project is the expertise to seamlessly take out a person from a photo, while maintaining the picture's integrity. Looking for someone who can: - Display notable past work where they’ve successfully performed the same task. Showcasing your expertise in object removal will give you an upper hand. - Must have an understanding of the intricacies involved in adjusting images. Experience in image retouching and high proficiency in photo editing software is a plus but more importantly, I'm after someone with a keen eye for detail, who can match the existing picture once the object is removed. Interested freelance...

My powershell script calls a function to get a filtered list of servers. When the filter returns a single server, (.count) or (.length) returns nothing. Only works when the filter returns multiple servers. Need help to debug and fix so it returns always.

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

I've had a hacking attack in the past and now need to regain my peace of mind by having an ethical hacker check my devices for security. The devices to be checked are my Windows computer and Android Smartphone. Desired Skills and Experience: - Proficient ethical hacker with experience in computer and smartphone security. - Knowledge of Windows and Android operating systems. - Ability to conduct a thorough security check and provide a detailed report of the findings.

I'm in need of a modern and minimalistic logo design for my yacht charter business. The name of the logo has already been decided and I'd like the design to reflect water and lake colors. I would like the logo to include a yacht that looks similar to my yacht, and I would like to see the words "Texas Forever Charters" I would like the yacht to have a Texas flag raised above it. **attached a picture of my yacht. Key Requirements: - The logo should embody a modern and minimalistic design style - neutral and earthy color scheme - Minimalistic and Clean design Ideal Skills: - Proficient in graphic design and logo creation - Strong knowledge of modern design trends - Experience in creating brand logos In your proposal, please provide a portf...

...project. Inside the presentation there is an animated segment on our marketing video that you must pay special attention to. Please mention the name of the main character in the explainer video so I know you watched it. Bids that failure to register and mention the character’s name will receive no reply. I am looking to build an automotive marketplace app that will have a range of features to make it user-friendly for both buyers and sellers. Key Features: - User registration and login, Search functionality, Listing creation and management - 24-7 Ai agents support, API integrations from multiple service providers - In app purchases, Context aware AI agents for tasks API Integrations: - Price comparison, GPS and mapping services - vehicle search API, Thir...

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building s...

For this project, I'm looking for an expert in machine learning and image recognition to develop a model that will accurately identify food objects from images: Key Objectives: - The model should focus explicitly on food items with the end goal being to assess the share of shelf products in stores. Please ensure that the model can identify a range of different food types, with a strong understanding of diversity in shapes, sizes, and packaging. - The final application of the image recognition model is for retail shelf analysis. Ideal Candidate: The perfect match would have experience with object recognition models, particularly food items and retail environments. Strong proficiency in machine learning and related software would be a substantial adv...

...HTTP method (GET or POST), and the selection of data to send as filters, such as by name, identification number, or both, similar to the functionality of Postman for configuring requests on endpoints. This form should enable the creation of multiple API configurations for consumption. The initial response must be mapped with a list of preset fields and then generate a new response with the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the detail of the record. Simultaneous connection with all configured and active API connectors must be possible, with clear indicators of succe...

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes