Remove duplicate words in excel cell vba trabalhos

I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confid...

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include sam...

...project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconc...

I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.

I urgently nee...smile produced by a camera malfunction in a photo of mine. Key requirements include: - Possibility to either fix the overlayed smile or completely remove it, depending on which option appears more natural. - Open to any level of modifications, from minimal to extensive that are necessary to restore a normal appearance to the photo. - An artistic eye would be preferred to ensure a seamless and high-quality outcome. As the nature of the job may vary dependent on the result sought, expertise in various forms of photo editing to fix facial distortions will be highly valued. Please have a portfolio showcasing similar work. Fast turnaround time is important. Note as well, that the changes may include correcting any whitening, straightening and gap-fixin...

...data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Content Creation with AI Tools: With the basic data in place, the next step involves using advanced AI tools to generate compelling and informative descriptions for each ser...

Looking for an expert who can develop an effective method for duplicating character equipment and gold cards in New Wonderland Online (HK), specifically for the PC platform. Key Requirements: - Must understand and have experience with MMORPG games, preferably "Wonderland Online." - Find an exploit to duplicate character equipment and gold cards simultaneously in the game. - Familiarity with WPE PRO or similar programs may be beneficial, but not mandatory as the old techniques associated with WPE Pro are no longer working. Please place your bid only if you're confident that you can solve this request. The game is relatively old, increasing the likelihood for success in the project.

I need an experienced financial analyst to create an LBO model urgently. The ideal ...provided assumptions. - Operating model and capital structure: You will need to build a comprehensive operating model, and structure the capital in line with the LBO requirements. - Sensitivity and scenario analysis: I expect you to provide a detailed sensitivity and scenario analysis that is easy to interpret. - I have a CIM and a template excel sheet that you can use to create the model. I have other instructions as well in which I will provide after you bid. Time is of the essence, and I need this completed within 24 hours. Please only bid if you are confident in your ability to deliver accurate results in this very tight timeframe. This needs to be done in 24...

...straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work efficiently without compromising on the quality of the data entry. Experience: Previous experience with similar data entry tasks, particularly with text data and spreadsheets, is highly desirable. A proven track record of delivering accurate and timely results in data entr...

...straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work efficiently without compromising on the quality of the data entry. Experience: Previous experience with similar data entry tasks, particularly with text data and spreadsheets, is highly desirable. A proven track record of delivering accurate and timely results in data entr...

I am looking for a talented photo editor who can help me with editing a small batch of photos. Key Requirements: - Color Correction: I need the colors of the photos to ...photos. Key Requirements: - Color Correction: I need the colors of the photos to be vibrant and appealing, ready for display on social media platforms. - Background Removal: Cleanly and professionally remove the background from these images, ensuring they look crisp and professional. - Quantity: The job involves editing one to ten photos. The ideal candidate will have a keen eye for detail and a strong portfolio that showcases previous experience in color correction and background removal. Experience with social media optimized photo editing is a plus. Please provide a link to your previous work in...

I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skil...aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggr...

I'm in need of a skilled individual to download a short video, lasting 20 seconds, and edit a specific phrase out. The phrase in question is "Microsoft Surface Ratt tillbehor gor halva jobbet". The successful freelancer for this task should have: - Proficiency in video editing software, like Adobe Premiere Pro, Final Cut Pro, or similar - Attention to detail to ensure the phrase is removed entirely and seamlessly - Quick turnaround time as the video duration is short - Experience with censoring specific words/phrases in videos The main purpose of editing is to remove the referred phrase without taking away from the content's coherence or quality. The ideal freelancer will have experience with similar tasks. Your bid should...

I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensu...

Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.

...am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented...

...exceptional photoshop expert who can digitally remove the sunglasses from a photo of me while maintaining a highly realistic, believable look. Ideal skills and experience for the job would be: - Proven expertise in photo editing and manipulation - Strong understanding of lighting and texture to keep the image realistic - Proficiency in Photoshop or similar image editing tools - High attention to detail - Previous experience in eyewear removal or similar projects appreciated My guess is the best approach would be to mask out the lenses of the glasses and apply some color adjustments to make the eyes behind the glasses look like the same shade as the skin (effectively removing the blue/green tint). And then to use the clonestamp tool to remove the rim...

I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The nu...

I need a seasoned photo editor experienced in moderate edits on headshots. Your tasks will include: - Perform moderate editing while securing the original color of the headshots - Tactfully remove stray hairs to maintain a natural look Expertise in Adobe Photoshop or similar editing software is a must. Prior experience in headshot editing and stray hair removal will be a major advantage. Your work should maintain a natural feel to every headshot, neatly removing stray hair without over polishing the images.

I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks. Key Responsibilities: - Data Processing: You will be required to process data including but not limited to sorting, filtering, and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft E...

I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.

I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able...

I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.

Quiero un bot para discord con funciones simples, y con una economia: "!dialy" te de unos puntos Que con "inventory" solo puedas ver tu inventario, una especie de leaderboard. "/add inventory [user] [item]" el item puede ser como la monedo o dinero de descuento. "/remove inventory [user] [item]" Quiero agregas unas cosas más.

I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of

We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills

...that the camera only changes the face I have uploaded in the UBER DRIVE application. UBER DRIVE is an app designed for food delivery personnel. It has a strict policy requiring a video of the account holder's face before work begins to prevent someone else from using another's account. Therefore, I want to create an app that can falsify faces and camouflage the UBER DRIVE app. The app specifications are as follows: The user creates an account in the app, then is charged a monthly fee of 50 euros, which may later be adjusted by the administrator. Only one face can be added by submitting a 3D video for facial recognition, facilitating the use of deepfake technology in the UBER DRIVE app. If a user wants to change the face, they must remove the firs...

I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data ...

I'm looking for a skilled professional who can modify the permissions on a PDF document. Specifically, I need to remove the 'Edit' permission, while ensuring the edited document remains compatible with all versions of PDF viewers. Key Requirements: - Remove 'Edit' permission from the PDF - Ensure the PDF remains compatible with all versions of PDF viewers Your expertise in PDF editing is crucial, as this task requires precision and understanding of PDF security settings. It's important that the finished document retains its functionality across different PDF readers. Please note that I'm not looking for any watermark to be added to the PDF. If you're confident in your PDF editing skills and understand the nuances of...

I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.

I am in need of a SharePoint expert who will be on hand for 4 hours daily to assist with various tasks relating to my SharePoint site. The selected individual will be primarily tasked with: - Document management: The organization, updating, and safeguarding of crucial documents. - Workflow automation: Streamlining business processes to improve effectiveness. - SharePoint site customization: Tailoring the site to suit our specific needs. At the moment, the specific SharePoint version being utilized is unspecified, so a basic understanding of multiple versions is beneficial. There's also a need to integrate Power Automate, so experience with this tool is essential. Ideal candidates must be proficient with SharePoint, organized, detail-oriented, and experienced in workf...

I require a proficient graphic designer to remove a medium complexity object, in this case a balloon animal from a photo. Key Details: - The task requires careful attention to detail in order to maintain the integrity and quality of the image post-edit. - Prior experience in object removal and photo editing is a must. - Expertise in graphic design software like Adobe Photoshop is expected. The ideal freelancer for this job would have prior experience and a portfolio that includes similar photo editing projects. This task requires advanced skills in photo manipulation and editing.

I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive spreadsheet featuring specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis ...

I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.

...report/dashboard in the form of mockup in Figma or Adobe XD Scope - 10 pages in total - 10 unique chart types - 10 charts are re used throughout the 10 pages What you need to provide: - Redesign existing design based on new brand directions - Provide mockup in form of XD or Figma - Mockup or design must be able to be implemented in Power BI. Power BI development is not in scope. - Redesign by changing font color and fonts (must be available on power BI) - Redesign by changing the color of existing charts. Chart design can only use original, can only change color font transparency - Add design elements like icons, lines, banners where u see fit - Re order the chart elements/cards where u see fit - Re size the dashboard page to ...

I'm looking for a talented individual who can creatively reshape a face, alter its hairstyle, and add/remove facial features on an existing 3D head model. The final output should exhibit a high level of detail, paving the way for an immersive 3D printing experience. The ideal freelancer for this project should: - Possess solid experience in 3D modeling, specifically in creating highly-detailed character models - Have a creative mind able to bring unique ideas for face reshaping, hairstyle alteration, and change of facial features - Be familiar with the specifications and level of detail required for creating 3D models intended for 3D printing - Ensure final design is primed for 3D printing, considering factors such as the overhang angle and wall thickness. Your ...

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM

I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.

Apply VBA code in new Excel file

...with Google App Script expertise to help me automate tasks specifically with Google Sheets and Gmail, WHATSAPP, SMS. Ideal Skills and Experience: - Proficiency in Google App Script - Prior experience in automating tasks with Google Sheets and Gmail - Strong understanding of integrating Google services Tasks to be Automated: 1. Generating Reports from Google Sheets Data: - The script should be able to pull specific data from my Google Sheets and generate reports automatically. 2. Sending Automated Emails based on Conditions: - I need the script to send out emails based on specific conditions. For example, if a certain cell in a Google Sheet reaches a certain value, an email should be triggered. 3. Updating Spreadsheet Data based on Email Responses: ...

...look closely, each URL has parameters which define search criteria. Make, model, price, mileage etc. are all parameterised in the query string. It is quite straightforward to decipher these. In the sample spreadsheet supplied I have started to create entries for Autotrader, eBay and Gumtree. These are incomplete but they give a good starting point. You will see that each URL replaces the paramater with a named cell from the spreadsheet. Out of scope Getting the lowest and highest price is a manual process. You do not need to do anything here. Some form of screen scraping would be required to do this. I would welcome thoughts on how to do this if you have skills in that area. Your skills To complete this job you will need: - Good communication...

As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe exis...

I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm l...

As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.

I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code doc...

I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. ...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

...Cart: A fully functional shopping cart allowing users to add, edit, and remove items. - User Registration: User registration and login system for customers to track their orders and save their details securely. Specific Integrations: - Payment Gateway: Integration of a secure and reliable payment gateway to facilitate online transactions. - Shipping Provider: Integration with a reputable shipping provider to ensure timely and efficient delivery. - Social Media: Incorporation of social media functionalities to enhance customer engagement and reach. Ideal Skills: - Proficiency in Drupal CMS, with a strong portfolio of e-commerce projects. - Knowledge of payment gateways and shipping providers integration. - Experience in creating user-friendly interfaces and secure ...

I'm in need of a professional developer who can create a web-based part navigation system for my business. The site should be user-friendly and similar to a few examples I can provide for reference. Key Features: - Search Function: The website should have an easy-to-use search function that allows users to quickly find the parts they need. - Sort by Category: Users should be able to navigate through different categories of parts, specifically for Electronics and Automotive. - Filter by Specifications: There should be a feature that allows users to filter parts based on specifications. The site should be sleek, modern, and easy to navigate. It should also be optimized for mobile use. Please note, I don't have any specific color scheme or branding preferences, so yo...