Vlookup column index number cell referencepráce

Do naší agentury WOO hledáme šikovného copywritera pro externí spolupráci na přibližně 10 hodin měsíčně. Na starosti budeš mít primárně psaní newsletteru a emailových automatizací pro jednoho z našich klientů. Pokud tvé prsty píšou jako múza líbá, umíš nacítit cílovou skupinu a přijmout tonalitu klienta za vlastní, neváhej a piš! Stačí poslat svou hodinovou sazbu a reference na tvou předešlou tvorbu a něco málo o sobě.

Dobrý den, poptávám vytvoření jednostránkového webu, který bude sloužit jako osobní webová prezentace. Moje představa: Jednoduchost a čistota Jednostránka Na úvodu foto v jedné části, v druhé text (představení) Níže text (skills) Reference 5x - logo firmy, osoba, pozice, text reference Kontakt Nechám si doporučit vhodné řešení. Předem děkuji za nabídku. S pozdravem, David

Zdravím, hledám zkušeného člověka který dokáže pomoct a poradit se získáváním kvalitních followerů na můj instagramový profil. Mám instagramový profil na kterém prezentuji svou fotografickou tvorbu. Především fantasy, akty(samozřejmě cenzurované pro instagram), glamour. Současný stav: Mám menší instagramový profil kam vkládám svou fotog...člověka, který dokáže vznést návrhy k vylepšení Forma spolupráce je na domluvě. Moje představa je cokoli mezi mentoringem a aktivní správou případně kombinací obojího. Předesílám, ž...

Hledáme profesionála nebo tým na Prestashop (máme PS 1.7.4.2) pro vlastní úpravy systému. Prosíme o Vaši cenovou nabídku (nejen hodinovou sazbu, ale přibližnou celkovou částku na základě níže uvedených bodů), dobu předpokládaného dokončení (docela na úpravy spěcháme). Také prosíme o reference a jak dlouho již s Prestou pracujete a jaké máte zkušenosti s vývojem modulů a zásahů do kódu Presty. Děkujeme. Požadavky na naše úpravy: 1) u každého produktu aby si zákazník mohl vybrat grafický podklad dle nabízené grafiky (viz. níže př&iacu...

OBRAZ – Obránci zvířat je nezisková organizace za účelem aktivní a efektivní ochrany zvířat. Vznikli jsme před 3 lety s ambicí zakázat ko...kampaňové microsites (webdesign, nasazení na WordPress) Příležitostná spolupráce do budoucna (údržba, nové microsites, rozšíření funkcí) Požadujeme: Dostatečnou časovou kapacitu v dubnu/květnu 2018 Zodpovědnost, spolehlivost a kreativní přístup k problémům Reference (stručný popis předchozích projektů / portfolio s kontaktem na referenty). Nabízíme: Spolupráci na IČO Rozumné finanční ohodnocení V p...

OBRAZ – Obránci zvířat je nezisková organizace. Vznikli jsme před 3 lety s ambicí zakázat kožešinové farmy v ČR – a povedlo se! K lednu 2019 u nás zaniknou kožešinové farmy. Během boje za zákaz jsme z nuly narostli do středně velké organizace. V roce 2018 spustíme druhou ve...spolupráci v první fázi (výběr a implementace) a následně průběžnou spolupráci v menší míře (dlouhodobá podpora, integrace s ostatními nástroji) – Spolupráci na IČO – Příležitost dostat nás z prachu a bídy Google Forms a dopomoci k přeměně OBRAZu na plně profesionální organizac...

...-dostupnost přes Skype v dopoledních hodinách Výhodou: -znalost a schopnost tvořit SQL dotazy (orientovat se v návrhu MySQL databází) -zkušenosti s GULP/GRUNT nebo podobnými -znalost CSS preprocesoru -základní povědomí o SEO -práce na plný úvazek (8 hod. denně) Potřebujeme někoho, kdo dokáže hledat a nevzdávat se při nacházení řešení v rámci složitějších úkolů. Pošlete nám prosím své reference (hotové weby - nejlépe na WP/pluginy/kód) kde demonstrujete své znalosti, také nám pošlete krátké info o sobě a sv&eac...

Vytvoreni reprezentacnich webovych stranek spolecnosti poskytujici konzultacni sluzby v oblasti stavebniho prumyslu. Klasicke schema s uvodni stranou, profil spolecnosti, poskytovane sluzby, reference, kontakt.

Zdravím, sháním člověka, který mi udělá podle mého soudu jednoduchý web dle zadání. Web bude zaměřený na hudební videa. Je důležité, aby obsahoval funkce dle popisu a abych si byl do budoucna jednodušší věci schopný spravovat sám. S Wordpressem trochu umím (dělal jsem třeba komplet web Casinogameronlin...zabrala zbytečně mnoho času. Hledám tedy někoho, pro koho není problém hlasová komunikace přes Skype, jednodušší věci lze řešit přes chat. Nebráním se případným změnám po předchozí domluvě. V příloze přikládám můj designerský master...

Dobrý den, Hledáme urgentně JAVA programátory, s minimálně roční praxí, pro vývoj bankovní aplikace. Požadujeme znalosti: Java, Spring, Hibernate, Oracle, Git. Komunikace probíhá přes JIRA. Finanční ohodnocení cca 3000 Kč / Den. Pro bližší info prosím pošlete CV nebo reference.

Dobrý den, hledám programátora se znalostmi PHP, javascriptu, SQL, Linux/ASP.net, HTML5, webGL pro vytvoření a vývoj webové aplikace. Hledám programátora pro dlouhodobější spolupráci. Líbí se mi Vaše reference. Máte zájem a časový prostor vytvořit pro nás novou aplikaci? detaily samozřejmě zašlu na vyžádání nebo předám při koverzaci

Jedna se o webovy portal s video obsahem dostupnym po zaplaceni (preview mozne zdarma). Je mozne pouzit predpripravene (opensource) CMS systemy a templaty. Dle detailne pripraveneho zadani vcetne mockupu (pdf, Balsamiq) je potreba vytvorit portal o cca 20 ruznych strankach. Stranky by mely byt v HTML5/CSS3/JS a PHP (PHP neni podmin...(kartou, paypal atd.), uzivatelsky login vice urovni, registrace uzivatelu a souvisejici administraci/redakcni system. Plan je, ze se portal bude dale rozvijet, cili mame zajem o dlouhodobou spolupraci. Soucasne zadani je pouze pro verzi 1.0. Cenu prosim rozdelte na programovani (pro tech 20 stranek), cenu za hodinu nad ramec zadani a cenu za graficky navrh. Nejdulezitejsim kriteriem jsou reference s ukazkou kvality grafickeho zpracovani a pot...

Dobry den, hledam programatora na node.js, mate nyni cas? Muzete poslat konatkt na vas? a nejake reference? Dekuji z vasi odpoved

Dobry den, hledam programatora na node.js, mate nyni cas? Muzete poslat konatkt na vas? a nejake reference? Dekuji z vasi odpoved

...využijeme 1.6 - Struktura webu, umožní vytváření editaci textových stránek/podstránek portálu ( články, FAQ, atď ) 2. Front end ( webová stránka ) - Dashboard - - Přehled nových poptávek ( z pohledu nabízejícího ) - Přehled nových nabídek ( z pohledu poptávájíciho ) - Zprávy 2.2 - Profil uživatele Zde uživatel bude moci přidávat své reference, informace o sobě, ceny, možnost rozdělit do různých "produktů" resp. služeb a jejich cenu za hodinu. Např. Focení: 250Kč / h , Zpívání - 5000Kč / hod atď. Profil uživatele se bude dělit na dvě skupiny "Poptáva...

Potřebujeme kompletní grafiku pro internetovou hru: NHLWIN - Hokejový manažer NHL" Doména: Na herní stránce je aktuální sestava tvého týmu tvořená ze tří lajn. Nad tím je kalendář odehraných hracích dnů a vedle toho informace o budoucích zápasech...Dole je seznam...Styl hover okének - např. když najedeš myší na kalendářík nebo na informace o následujícím hracím bloku. ...možná by bylo lepší zmenšit celkovou šířku -- dejme tomu na 1024. pro inpiraci můžeš nahlédnout na hotové fungující projekty zaměřujíc&iacu...

Hledáme schopné kodéry webových stránek pro krátkodobý projekt. Náplní práce jsou kodérské práce - převedení .PSD formátu do HTML a CSS s aktivními prvky. Požadujeme: - zkušenosti s html a css - reference - rychlé jednání - výsledky a především schopné lidi Výhody: - dobré platové ohodnocení - práce na významném projektu

Hi Taras, here is the other project I was talking about, as alot of my posts there are a few parts to this. 1. is designing a layout of liners for a feeder, I will give you a reference image to go from 2. Is increasing the thickness of existing liners and ensuring they do not run into one another.

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred

...promotional video along the screen recording of application video, which I have. Key Project Information: - Purpose: The goal is to create a catchy video to promote a product. - Footage: I will provide the raw footage along the screen recording application video - Editing Style: I prefer the video to be fast-paced and energetic. Output: (1 video) 30 seconds (1080x1920) - Portrait Output reference: Sample of RAW footage attached** Skills Required: - Efficient in any popular professional video editing software. - Familiarity with basic filmmaking styles and techniques. - Ability to maintain a consistent visual style. - Ability to interpret and implement feedback effectively. - Strong time management skills and the ability to meet deadlines

I'm searching for a stellar developer who can construct smart contracts on TON. The ideal candidate for this job is someone who understands FunC language like the back of their hand. Key Task: - Develop smart contracts on TON for staking propuse. Preferred Skills &...Develop smart contracts on TON for staking propuse. Preferred Skills & Experience: - Extensive experience in coding with FunC language - Familiarity with TON and its smart contracts - Understands best practices for smart contract development and security This project offers the right candidate the opportunity to show their creativity and problem-solving skills, as there are no set requirements or reference examples to follow. We are ready to hire you right now, and can hire for more project with long t...

I need a skilled Photoshop expert to digitally change the color of a black leather reformer to custom colors. - Task involves using Ivory and Taupe from our custom color catalogue. Website will be provided for reference. - Accuracy in reflecting texture and color in the rendered images is imperative. Ideal Experience and Skills: - Expertise in Adobe Photoshop - Ability to work with a tight deadline - Previous experience in product color alteration projects is highly beneficial.

...(ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed solution to use Python, as it's the language I'm most comfortable w...

The project is hosted on GitHub: The current state of the project is stable and operational. It currently relies on an API connection to fetch movie data, utilizing the public API provided by The Movie Database (TMDb): The upcoming task involves a simple modification: removing the API dependency. Instead, the project will transition to using static information. Additionally, it will integrate functionality to play videos directly from specified URLs. This adjustment aims to streamline the application's functionality and enhance performance.

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inve... Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I'm in need of a proficient 3D designer who can innovate 6 projects (3d art project) the art piece should resemble a theme ( Youth flighting against family and society norms). I have provided a sample of some sculptural art that I think can be a reference to what I expect to have when it comes to quality. I need the 3d art provided to be simple but yet match the above mentioned theme. The art work has to be original the files provided should be .stl files as I can print using a 3d printer Key Skills and Experience: - Expert in 3D art design - Proven creativity in past projects - Mastery of 3D design software I need this project to be done with in a week. deadline 27th of April

I need a professional to perform pre-employment vetting. This should include conducting thorough background checks, drug testing, and making relevant reference checks for potential full-time employees. Key Skills and Experience: - Familiarity with all aspects of HR pre-employment vetting - Reliable techniques for background and drug checks - Proven track record with similar jobs - Excellent communication and reporting skills Unfortunately, I do not have a stipulated timeframe for completion, and am open to discussion in this regard. Therefore, flexibility may be beneficial. However, please bear in mind that quality will be valued over speed in this project.

I'm looking for a talented graphic designer to produce an engaging, sports-themed t-shirt design. The design concept is based around a specific athlete and includes relevant copy. Your role would involve: - Creating an impactful graphical representation of the selected...printing on t-shirts. Skills and Experience: - Proficiency in graphic design software. - Demonstrated experience in creating sharp and entertaining illustrations. - Experience in t-shirt graphics would be a plus. - Excellent communication and interpretive skills to fully understand and align with the project's vision. - Must supply Vector images I would provide reference photos and copy. I need you to put it together. I've attached a reference photo. I want a person drawn in this position and...

I'm interested in ...backdrop. While the architectural magnificence of the building should be captured, the photo should also reflect the vibrant life of the city with elements of street views unique to NYC. Here are some specifics: - The photo needs to be taken during the evening hours. Perhaps capturing the essence of evening lights will add to its charm. **** Lastly, please note this photo is meant to serve as a reference for artistic work, and while it needs to be aesthetically pleasing, it needs to accurately represent the city's streetscape and the Empire State Building. Ideal candidate: - Skilled photographers with expertise in street photography - Prior experience capturing cityscapes during different times of the day and seasons - Strong understanding of ligh...

I'm seeking a proficient artist who can design a lively, cartoon-style illustration of the Oberlin College white squirrel in the classic "Heisman" football pose. The illustration should radiate playful and happy emotions and be set against a realistic football field. The ideal freelancer for this project would hold: - Significant background in vibrant an...effectively research Oberlin College's iconic white squirrel and football field scenario Creating a piece that marries both the fun nature of the squirrel and the rigorous spirit of the sport is the goal. please use the photos as a guide. it is basically just a meld of the squirrel and the heisman pose photo (black and white). The picture of the football players is just for color and design reference for th...

We sell honey and we need a graphics designer who can create beutiful and eye catching images, product packaging and product detailed. Our Compititor listing for your reference- What I need: 1. Package design, I will provide logo 2. 6 images with graphics that attaract buyer Need high quality and freelancer need to be creative.

...going to be separate for all pages. The header is supposed to be a branch of a tree with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage...

...Combine live-action and animation seamlessly. A background in both types of video production is highly appreciated. 3. Appeal to an adult target audience. Therefore, a mature and refined style is necessary. Target audience - crypto investors traders Previous work with live action-animation hybrid content and familiarity with adult viewer preferences will suit this project well. All script, video reference points, and documents will be supplied. However, creative input is valued....

I need to manually add text and picture annotations to a PDF document . I have a pdf document but pictures do not show up some places in the document, I have the pictures and need someone to have two columns with the original on the left and add the pictures in a second column on the right of the original document where they should have been inserted . there are about 15 photos that need to be matched up . should not be more than 2 hours . also there are 8 names that need to be inserted wherever they show up in the document .

I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Ability

I need a skilled Flutter developer to create a medical diagnostic app. This app will be used to collect blood cell images or videos. Here are some specific features the app will need: - User authentication - Push notifications - In-app purchases Also, the app should be capable of capturing and storing High-Definition (HD) images or videos. If you're adept with Flutter and have some experience in creating medical or diagnostic apps, your expertise will be highly desirable for this project.

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product...Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column...

We have an existing logo for our business and now we need a font designed for our business name that will compliment our logo. Looking for something that will look natural with the logo, the shop is greek themed so most likely some style of block lettering. The font my be 100% original. the name of the shop is "The Apollo Tattoo Studio" our logo is attached for reference.

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

...and blog post templates so that we may add future webpages. 6 Pages and a Blog * Homepage: Main landing page * Job Board (leverages WP Job Openings plugin) * 4 subpages: 1 for each of our services 1. Employers seeking permanent placement candidates 2. Companies seeking consultants 3. Executive Search 4. Job Seekers * Blog page * Standard blog functionality * Acts as an index * Can add blog posts via Wordpress * Searchable by date, keyword, category, etc. The menu will include links for the homepage, “Our Services,” Job Board page and blog page. The 4 subpages will be linked in a submenu under the “Our Services” heading. The blog menu entry can be removed from the menu so as not to be accessed until I choose to turn it on. ...

I'm on the lookout for a skilled graphic designer who can craft a modern, sophisticated logo for my men's bespoke tailoring business. The design should encapsulate a sense of simplicity and sophistication. Key Points: I have Attached One Reference Logo with this post, Exactly I need the same logo with my Preference. ( Actually that Attachment logo indicate Bow and wood texture but I need Bow and Weaving or Thread like texture) *Should indicate any Tailor thing like ( BOW-TIE) *Should looks like Fabric weaving design inside the Logo *MENSPOKE font should be clear and Readable should be Unique. *For Shirt branding like Pocket Embroidery also it should looks good and visible.

...web design to ensure the app is accessible across various devices. - Experience with building secure authentication and user profile systems. - Capability to integrate payment systems for subscription management. Objective: To create a unique digital experience that combines traditional tarot readings with modern technology, providing users with insightful, personalized readings. Inspiration Reference: For an understanding of the visual and functional expectations, please refer to this video: which outlines similar WebGL implementations in web applications. Project Deliverables: - Complete source code of the application. - Documentation detailing the setup and configuration of the app. Timeline: Please provide an estimated timeline for completion

...This new logo will be used on our website and on our social media platforms, making it essential to be visually effective in both large and small formats. Specific Requirements: Colors: The design must incorporate the color palette of the current logo. Design: The design should be original and clearly differentiate from our current logo and from free online examples which I will attach for reference. These examples are just to indicate styles or elements we like, but the final design must be unique. Adaptability: The logo should be easily adaptable for use in digital formats (such as website headers and social media profiles) as well as printed materials. About Us: We are Cubaherald, an online newspaper dedicated to covering relevant news from Cuba, Spain, and the United States...

I am looking for a Flutter developer to create a comprehensive PDF package. - The package should include functionality for: 1.) PDF encryption and decryption 2.) PDF compression 3.) Splitting PDF into multiple PDFs 4.) Merging multiple PDFs 5.) Wat...Add page no. to the PDF 8.) Change PDF page size IMPORTANT: Do not use any underlying technology which requires AGPL-3.0 license or any other license which asks for fees for commercial use. Platform Support: - The Flutter package should be able to work seamlessly across both iOS and Android platforms. Exhaustive documentation will be required for the package. Example flutter package (for reference only): Payments will be done in phases after completion of each feature and it's related documentation.

I'm seeking an experienced professional in WordPress site optimization to enhance my website's page speed. My target is a score of 70+ and a speed index below 2 seconds for the whole site. Key tasks include: - Run a thorough audit of the website to pinpoint speed issues. - Implement the necessary changes to optimize page speed. Skills and expertise required: - Proficiency in WordPress platform. - Deep understanding of website performance optimization. - Ability to perform a detailed audit and execute the needed changes. - Proven track record in achieving 70+ page speed scores and sub-2s speed index. I'm looking to get this project completed as soon as possible. If you have the skills and availability to deliver fast results, please get in touch.

I have an AutoCAD DWG file for an urban design project. I'm looking for a 3D modeller to create a block model 3D representation of the design. Key Det...bus-stop etc. - The 3D model does not need to have textures or colors. Ideal Skills and Experience: - Proficiency in AutoCAD and 3D modelling software. - Previous experience with architecture projects. - Ability to work with medium level of detail, staying faithful to the design's overall intent. - An understanding of spatial analysis in urban design would be beneficial. I have attached 2 reference images. These will be the final output which I will further detail out on Photoshop, for that I need the base model. If you're confident in your 3D modelling skills and have experience in similar projects, I'd lov...

I'm looking for a professional videographer and editor to create a stylish and informative video primarily for marketing purposes. This video will be targeted at businesses, not the general public, and should convey a strong, concise message. Ideal Skills and Experience: - Proficiency in video editing software - Prior experience in creating...and our target audience. From there, you'll use your creative freedom and expertise to produce a video that is not only aesthetically pleasing but also serves its purpose as a powerful marketing tool. Please reply with your portfolio showcasing your previous B2B work or similar projects you have undertaken in the past. Take this below link as a reference for the same

...out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively. The 5 different grading options are: Not yet started Not yet submitted Submitted for marking Partially Complete - More work to su...