Why are these formulae not returning the same result when they should (multi-criteria met)? =if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH($A9,FP$4:FP8,0),1),IFNA(index($A10:$A204,MATCH(true,'3. Sorted by Density'!FP10:FP205,0)),"ORPHAN"))) vs =if('3. Sorted by Density'!FP9=TRUE,ifna(index($A$4:$A8,MATCH(1,($A9=FP$4:FP8)*(FW:FW=FW9),0),1),IFNA(index($A10:$A204,MATCH(0,(true='3. Sorted by Density'!FP10:FP205)*(FW:FW=FW9),0)),"ORPHAN")))
Utilizing my company logos and website, I need a graphic design for a double sided rack card and a post card that I can use somewhere like Vistaprint to get them made. The rack card and post card can be similar/same styling. Website is
My company is looking to hire two blog writers that are familiar with the English language and can operate Wordpress. These blogs are for our clients based in the swimming pool industry, so if you know facts about pools and construction that is a plus. The project is monthly and set up to become long-term if desired. the pay is $10/blog. We have many clients, so that we can range anywhere from 50-60 blogs a month.
Hello! I need a virtual assistant on a weekly or monthly basis to do regular assistant work including making and receiving phone calls. Experience is preferable. For Portugese individuals. Thank you for checking it out.
Hi, I have a waterski brand and need some help with some logos to print onto clothing etc. I have designed some logos but need someone to turn them into a logo I can actually get printed ( correct format etc ) also someone to help make new ones for our business and expand our design image for the future? I have 4 of my own designs I would like fixed up and converted into a format i can print and maybe another 2 designs to print onto clothes. Thank you
I need some graphic design. Looking for a graphic designer to re-create an existing logo. Original file was lost by company. Also need to design layout of tradeshow booth tablecloth and banner. Images will be provided. Colors need to be identified and given to company. Brochures and rack cards are also a consideration once branding is determined. Two stages of projects. Recreating current collateral and then a relaunch in January 2023. For now, re-digitizing / re-creating is at the forefront. Need items created quickly and efficiently. Format to include jpgs that are for web use and print use (hi and low res images to be created). Cleaning up the lines and streamlining the logo would be considered.
I just started a new YouTube automation channel, and I need to consult with an expert on several issues related to channel growth strategies, team development, etc. I need someone with a proven track record, who has been able to grow & monetize multiple channels. I will need to schedule a call or two with the freelancer within the next few days to discuss some of the issues I have and ask a few questions I need help with. If you are interested in this job, please provide a list of channels you've created, date of creation, number of videos and subscribers. Thanks.
I need a logo that will be trade marked to use on my website, banners, business cards, etc. My domain and website will reflect "Uncle Yeti Wood Workins" by GG Creations LLC Las Vegas, Nevada. I work with live edge wood, electricity, and resin to make home decor such as key hooks, hat hooks, gun mounts, and wall art. Some of my pieces include wildlife such as bears, elk, deer, and wolves. The tools of my trade are saws, sanders, measuring tapes, routers, stencils, etc. I am looking for a logo that really stands out and isn't just words. The logo should include an unforgettable DRAWING of a yeti (not sasquatch) as well as the domain, business name, and location.
We are looking for a Bookkeeping Manager to join our team. If you are someone who likes working in a fast pace environment, solving complex problems, and helping small business owners track and understand the financial side of their business then we have a great opportunity for you! In this position you will be required to maintain QuickBooks Desktop and Online bookkeeping accounts regularly. Including accepting transactions through the bank feed, adding assets and liabilities to the balance sheet, adjusting certain payments and deposits for principle and interest payments, tracking and adjusting payroll accounts, etc. You will also be required to assist in the initial set up of clients accounting records as well as payroll accounts. This position will require client interaction and helpin...
I'm working in research and casting on an episode on SPINE HEALTH - and the importance of ergonomic design on spine health. I would love to feature an ergonomic designer expert who can assist various cases on camera. To be filmed in NYC. Must have experience designing offices or furniture with ergonomics in mind, and spine health related experience.
...these models will be used to create and cast real-life jewelry. The design will be make through close collaboration with us and the customers to review prototypes and refine the concepts as needed. The number one responsibility of this position will be to bring the customer’s dream to life and ensure their satisfaction with their custom piece. Future projects will be everything from fine jewelry to customized hip-hop pendants etc. If you only specialize in one category for example fine jewelry, do not hesitate to take contact! The most important for us is that you are a super skilled jewelry designer and create. Wether it is in one category or all around we will happily work with you. Please attach your portfolio of previous work. We will then revise it as soon ...
I need a UI/UX Designer to build a landing page aimed at selling professional courses. The landing page must have a modern design (something similar to web3 application interfaces). The landing page must present, not respectively, but necessarily: Presentation of our company Presentation of our differences Presentation of our courses/products Presentation of our statistics (students graduated, certificates issued, etc.) It should be a convincing page. The focus is the sale of our courses/products. New sections for the page may be requested
My company is looking to hire two blog writers that are familiar with the English language and can operate Wordpress. These blogs are for our clients based in the swimming pool industry, so if you know facts about pools and construction that is a plus. The project is monthly and set up to become long-term if desired. the pay is $10/blog. We have many clients, so that we can range anywhere from 50-60 blogs a month. Requirements -Copy write an 800-1,000 word article -Use word press previously -Write in English
Need to make 70 different caricature colored drawings 6.5"x 4.5" size of famous people for our project. Needs to be completed in 1 month.
I have a disability management company that focuses on health, return to work, wellness and completing medical assessments. Looking for a logo which encompasses health, wellness and integration to work. looking for a logo that is modern in design would like the colours to be blue and silver but am open to other ideas Name of Company is: R.K. Disability Management Solutions
I need a logo for a mental health for people of color, something inviting and speaks community. I would like to see the logo on t shirts, facebook/Instagram profile image, hoodies, cellphone cases etc n Colors: Attached Logo Name: The Healing Circle LA Motto: Lets Heal Lets Build
I need a UI/UX Designer to build a landing page aimed at selling professional courses. The landing page must have a modern design (something similar to web3 application interfaces). The landing page must present, not respectively, but necessarily: Presentation of our company Presentation of our differences Presentation of our courses/products Presentation of our statistics (students graduated, certificates issued, etc.) It should be a convincing page. The focus is the sale of our courses/products. New sections for the page may be requested.
I am a wedding and special occasion videographer. I book work from weddings to birthdays to christenings and all other types of occasions. I want to create a DVD sized template where I can deliver my completed edit to my clients. I usually give them either a DVD or Bluray. I want a design that will be consistent with the different types of occasion...can deliver my completed edit to my clients. I usually give them either a DVD or Bluray. I want a design that will be consistent with the different types of occasions. Im not looking for separate designs for each occasion. I really like contemporary, minimal designs but not too corporate looking. I have uploaded my logo to be used in the design. The designer has full creativity in the creation of the template, even altering the logo, if...
Tasks are to submit some ads to multiple paid sites. You must have all tools vcc, cc etc Any bid from outside the united states, Canada, Australia and United Kingdom.. WILL BE REJECTED!
...management, and transform the success rate of their projects with confidence. Do you want to work in an environment where you and your contributions are truly valued and you can learn and grow? Then Project Control Academy wants to hear from you! We are looking for an experienced Graphic Design Specialist who possesses the maturity, passion, and energy to collaborate with others on the team. We need someone who can see beyond what is presented and design creative visuals that excite and inspire. As the Graphic Design Specialist, your primary responsibility will be creating attractive and engaging digital banners, posters, flyers, brochures, and graphics for our training programs, services, brands, and events. The ideal candidate is a creative, self-motivated team pl...
I am looking to make a flyer campaign for a car wash in Montreal, Quebec, Canada. I was intending to put stand up displays in neighboring businesses. This campaign will have no fold 4 by 8.5 brochure type flyers (SEE ), the 4+1 display in the bigger businesses and the single stand up in the smaller businesses. I would like equally that the designer size the coupons so we can use them in our sandwich board displays and the inside signs in our business. I like the idea of having a vibrant, multi colored 4 brochure +1 (8.5/11) display (SEE ) with services offered. Each flyer will offer 1 service with a 5$ off coupon at the bottom for each type. Design is of the essence, I am looking for a very catchy and trendy design. Vibrant colors, that get attention are a must. a quality stock
I need a sound designer to score some of the dance for Love Alone. Background: Choreograph Historically, I create abstract movement-based performances through working with others. Improvisational structures, generated in collaboration with dancers´ specific bodies and imagination, form the vocabulary from what we make together. The language of these dances is inclusive, inspired by the performers I work with, who help me find the “voice” of the piece. danceTactics performances are forged in kinetic beauty– detailed, rigorous, passionate, but resisting singular meanings. My collaborators and I are committed to creating dance performances where audiences bring more of themselves to the experience. Love Alone: 18 Elegies for Rog, which author and activis...
Hi, I am looking for a Salesforce developer who can mentor me with development and admin tasks. This is going to be a long-term ongoing engagement. Tasks will be related to creation of flows, profiles , connectors, roles, ci/cd deployments , dataloader, defining profiles, creation of profiles, Salesforce financialforce integrations with SAP, Concur, workday, etc FinancialForce experience is a plus.
*Developing and implementing effective Organic SEO strategies *Keyword analysis *Implement link building campaigns in coordination with client SEO goals. *Coordinating content, design, social media, pay-per-click (PPC) marketing and other activities *Provide recommendations and execute strategies for content development in coordination with SEO goals general and keyword specific. *Managing offsite and onsite optimisation projects and reporting on performance *Analyzing and maintaining SERP positions for the keywords *Execute tests, collect and analyze data and results, identify trends and insights in order to achieve maximum ROI in organic search campaigns *Ability to manage details, overall flexibility and efficient work habits *Should be able to organize and improve web marketi...
Looking to have logo designed for our race team , something to put on t shirts , decals for trailer , something colourful , some dark green and bright yellow “ williams brother racing “ incorporate pictures of our race truck and car into background some how
Hi there, I need someone to edit a graphic for my company. It has to be perfectly edited, no errors will be tolerated You must change the company logo, name, and address on our previous company mission statement. Will pay a quick $20.
I am looking for a freelancer to do 2 x internal and 2 x external photorealistic renders of an 8 x townhouse development. I have architectural floorplans that can be used as the basis of the renders and the BIMx file available. Some screenshots of the BIMx file are attached for reference. If possible, it would be great if someone could also edit it in to the google map imagery for the location to give it a realistic background, but that's not strictly necessary.
3 short term projects for our charity: 1. Designing 2 pull up banners in line with branding and website 2 Designing template for first annual social impact report. 3 Designing social media collateral for Christmas campaign launching on 25 Nov