Excel find duplicate values columns jobs

I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )

...and real estate services. There will be a Real Estate Appraiser section also. Key Features: - Property Listings: A comprehensive section for displaying available properties. - About Us: A dedicated page introducing my agency and its values. - Contact Form: A simple, efficient way for potential clients to get in touch. - Featured Properties: A special section for spotlighting select listings. - Appraisal: Describing real estate appraisal services. The website will need to incorporate an advanced search functionality with filters, allowing users to easily find properties based on their specific needs. Ideal skills for this project include: - Proficiency in advanced web development and design - Experience with creating real estate websites - Expertise in implementing adva...

Please Sign Up or Login to see details.

...adapt to different audiences. • Strong understanding of budgets, targets, and product pricing. • Proficiency in analysing sales data and making data-driven recommendations. • Self-motivated and proactive with exceptional organisational skills. • Proficient in Microsoft packages including Excel and PowerPoint. • Knowledge of graphic design is an advantage. Join our team as an Amazon Account Executive and take your career to new heights! Apply now and be a part of a dynamic and innovative organisation that values your skills and offers growth opportunities. We offer a competitive salary package and a vibrant work culture that encourages collaboration and creativity. Don't miss this chance to make a significant impact on the organisation's...

I'm seeking a skilled researcher to help me with a project focused on customer behavior in the ready-to-eat and cooked food sector, particularly concerning purchase patterns. Key Tasks: - Locate 8 datasets (freely available and downloadable) and research papers of good quality focused on customer behaviour related to ready-to-eat or cooked food. - Find datasets on which machine learning models have been applied in such research papers. Ideal Skills: - Experience in data analysis and research. - Familiarity with customer behaviour studies and machine learning. - Ability to locate and assess the quality of freely available datasets and research papers. I look forward to your proposals.

I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice

I'm seeking a proficient PowerPoint designer to create a modern and clean company portfolio. The primary aim of this presentation is to highlight our company's achievements. Key Aspects to Cover: - Company history and values: We want to showcase our journey, our ethos, and what makes us unique. - Products and services: A comprehensive overview of what we offer, presented in an engaging and easy-to-understand manner. The ideal candidate for this project should have: - Extensive experience in PowerPoint design. - A strong understanding of modern design principles. - Previous experience creating corporate presentations. Please provide examples of previous work, especially if it aligns with a modern and clean aesthetic.

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.

We are a startup freelancing company looking for clients in various fields, including websites, mobile/desktop apps, AI engineering, and UI/UX design. Your task will be to find potential clients for us. For every client you find, you will earn 10-20% of the overall profits, depending on the complexity of the project. If a project is valued at $1000, you will receive $100-$200 for finding the client. Please feel free to DM me to discuss more about the advertising! Ideal Skills and Experience: - Strong networking and communication skills - Experience in client acquisition for tech services - Understanding of various tech fields - Proficient in content marketing strategies

Please Sign Up or Login to see details.

I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.

...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to presen...

...ensure deadlines are met. 5. Sugarcrete Initiative: Research and compile a list of bagasse suppliers in Belize for future brick manufacturing. Track costs related to Sugarcrete separately from gym expenses. Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week...

I'm looking for a robust string generator that can create strings based on specific rules. The strings will primarily be composed of alphanumeric characters and three basic arithmetic operators. Their length will vary, ...and three basic arithmetic operators. Their length will vary, being a minimum of 4 characters and a maximum of 6. Key requirements: - The output should be in plain text. - The strings need to undergo several validations: length validation, character set validation, and pattern matching validation. - The patterns do not need to follow a predictable sequence, but there will be multiple possible values in terms of length. Ideal skills for this project include experience in string manipulation and data generation, with strong attention to detail for the requir...

I'm seeking an experienced developer to review and fix my multi-chain arbitrage bot script. This bot is designed to find and act on profitable trades across decentralized exchanges (DEXs). I have been encountering a number of error messages. The execution failures occur mainly when I'm testing the script, and I'm primarily interested in bug identification during these tests. Key Responsibilities: - Debug the source code and resolve error messages. - Test the script on my VPS and provide feedback on issues encountered. - Identify bugs during the testing process. - Offer suggestions for improvements. Ideal Skills and Experience: - Proficiency in coding, particularly in languages used for DEX trading bots. - Previous experience with multi-chain arbitrage bots. - Famili...

Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...

...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...

...the book is to teach kids about the environment, animals, and nature in the Mobile-Tensaw Delta regions in South Alabama. The story is about Captain Steve teaching Brody and Samantha about the nature in their own backyards and finding two fishermen torturing the resident gator Hooks by catching him on the fishing line. They did it on purpose, but no one wanted to fess up to it. Along the way they find herons and do some heron Thai Chi or Yoga and participate in the Shellfish Shimmy with some animals. There are a couple things that I really would like to stay in the story like some lines that Captain Steve needs to say because the character is based on a real person. Looking at around 2000 - 2500 words for the book and will share the illustrations and what the book is currently ...

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I'm in need of a unique and stylish evening gown designed. Key Requirements: - Expertise and creativity in evening gown design - Proficient understanding of chiffon fabric and its properties - Ability to deliver a design that's both aesthetically pleasing and functional Please provide examples of your previous work in evening gown design, particularly those made from chiffon. Please find attached brain storm of what I have in mind, and advise with your proposal

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience

I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets

...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...

I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel...

...features include: Simple Uploads: Effortlessly upload videos, photos, and PDFs. Instant Monetization: Set prices and earn in real-time. Secure Transactions: Robust payment processing ensures quick and safe payments. Global Access: Support for multiple currencies and languages. Real-Time Tracking: A sleek dashboard to monitor sales and performance. We need a logo and app icon that represent the core values of the app: creativity, simplicity, professionalism, and global accessibility. Requirements for the Logo: A clean, modern, and versatile logo design. Incorporate the app’s name or initials creatively. Use colors and typography that align with themes of digital innovation and creativity. Provide versions for light and dark backgrounds. Deliverables in high-resolution form...

I need a professional who can help me extract data...POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my accoun...

billing_last_name and billing_first_name columns. How can I get to show only one column on mobile devices? billing_address_1 and billing_phone. How can I get to show only one column on mobile devices?

I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets

I'm experiencing issues with my MySQL ADX formula. The calculations are producing incorrect data output, specifically wrong values. The issue seems to occur during the calculations phase. Ideal skills for this project include: - Proficiency in MySQL and data analysis - Strong understanding of ADX formula mechanics - Experience in troubleshooting and fixing data calculation issues I need a freelancer who can quickly identify the problem and provide a solution.

...aggregates various beauty service providers including hair salons, spa and wellness centers, and makeup artists. Key features of the website will include: - A primary function of service booking. This will require a seamless, user-friendly interface that allows customers to easily book appointments with their desired service providers. - A search bar equipped with filters. Users should be able to find service providers based on specific criteria, enhancing their browsing experience. Ideal candidates will have: - Extensive experience in developing e-commerce or service booking websites. - A strong portfolio demonstrating their ability to create interactive, user-friendly web interfaces. - Excellent understanding of implementing a search bar with filters. Please include example...

...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of...

I'm looking for a professional teste...my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management. Experience with secur...

Automated Functions: Bots can automatically moderate chats by deleting inappropriate messages, banning users, or applying time-outs. Customization: M...server. Utility Features: Bots can integrate features like weather updates, reminders, notifications, or even translation services. Leveling Systems: Many bots allow for gamification within the server by assigning XP and leveling up based on user activity. API Integrations: Bots can integrate external APIs to pull real-time information such as gaming stats, news, stock prices, or cryptocurrency values. Custom Commands: You can configure bots to respond to specific phrases or create shortcuts for frequently used commands. Welcome Messages: Bots can greet new members with welcome messages and assign roles automatically when they join t...

...order delivery from a local pizza place. Guests will scan a QR code on the wall that directs them to a WordPress landing page. The page will display the pizza place’s menu, allow them to place an order, and earn us a $2 commission per transaction. This is a test project, so we’re looking for a quick solution to integrate into our WordPress landing page. --- **Project Scope for Developer** 1. **Find a Pizza Place**: - Identify a pizza place in **19124 ZIP code** that delivers and uses **Toast POS**. 2. **Menu Integration**: - Write code to **dynamically pull the pizza menu** from Toast using its **API** for real-time updates. 3. **Display Total Cost**: - Calculate and display the total price: - **Pizza total** (from Toast). - **Our $2 commission...

... digitalization, and marketing. We aim to boost business efficiency and support growth by providing structured advice and implementing digital tools. We also focus on building a strong online presence and offering strategic guidance. About the Project: We are seeking a talented and creative logo designer to create a visually compelling and memorable logo that represents our brand and its core values. The logo should convey: Efficiency and Optimization: Reflecting our focus on streamlining business processes. Digital Innovation: Highlighting our use of technology and digital tools. Growth and Support: Demonstrating our commitment to helping businesses thrive. Trust and Reliability: Establishing us as a dependable partner for entrepreneurs. Responsibilities: Develop several init...

...lounge, such as: - Lounge Name - Airport Name & 3-Letter Airport Code (IATA) - Terminal and other location details - Access Type (e.g., airline-specific, membership programs, or pay-per-use) - Operating Hours - Amenities and services offered - Ensure all data is accurate, up-to-date, and categorized appropriately. Deliverables: - A structured CSV file containing the compiled lounge data, with columns clearly labeled and formatted for easy use. Ideal Candidate Qualifications: - Proficiency in Research and Data Collection: Strong ability to gather, verify, and organize information from multiple sources. - Familiarity with Airline and Lounge Systems: Knowledge of airport operations, frequent flyer programs, and lounge networks (e.g., Priority Pass) is highly advantageous. - ...

I'm encountering issues with my MySQL ADX formula which is yielding incorrect values. This formula is being used for trend analysis on sales data. Ideal Skills & Experience: - Extensive experience with MySQL - Proficiency in crafting and troubleshooting ADX formulas - Background in data analysis, specifically sales data - Ability to deliver accurate results in a timely manner.

...years of experience in the market. We are currently looking for an Advertising Specialist to attract advertising partners through various websites. ? We work with different geolocations. Our platform is a marketplace that opens new opportunities for gamers and redefines the approach to virtual in-game items. ? Responsibilities: • Sending outreach emails and messages through various websites to find new advertisers and establish partnerships; • Establishing and maintaining contact with potential and existing partners; • Discussing cooperation terms, negotiating prices and timelines; • Monitoring the timeliness and quality of partners’ performance of obligations. ? Our Expectations: • Excellent communication skills and the ability to quickly es...

I use CapCut to edit my videos but it’s choppy. Need some advice on how I can improve my videos. I am also open to trying another app to edit my videos on my phone. I edit on my phone and record on my phone. I find that my videos are losing focus sometimes when I record in CapCut. I uploaded a video. I’m not looking for anyone to edit videos just some guidelines to make my videos more eye catching and less choppy

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

...communicates its message. This project will leverage innovative artistic direction, storytelling techniques, and cutting-edge production to captivate the target audience. --- Scope of Work 1. Pre-production: Concept Development: Brainstorming ideas that align with the brand’s identity and message. Scriptwriting: Crafting a compelling script that integrates the narrative with the brand’s tone and values. Storyboarding: Visualizing the narrative through detailed storyboards to plan shots and sequences effectively. Visual Planning: Finalizing artistic styles, color palettes, and mood boards for consistency. 2. Production: Filming: High-quality shooting using professional-grade equipment. Lighting & Sound Design: Ensuring optimal visual and audio clarity ...

Are you a motivated individual with excellent communication skills and a knack for finding opportunities? We’re looking for an Appointment Setter to join our growing Website Design Agency team. Your role will be to: Research & Identify Leads: Find businesses without websites or those with outdated/bad websites. Reach Out to Leads: Use personalized messages, emails, or calls to introduce our services and highlight the value of having a professionally designed website. Set Appointments: Once leads express interest, book them for a call with our team. What We Offer: Commission-Based Earnings: Earn 10% commission on every deal closed from the leads you bring in. For example, if a deal is worth $5,000, you earn $500! Growth Opportunities: As our agency expands, there&rsq...

Please Sign Up or Login to see details.

...team with expertise in Off-page optimization and guest posting, to help rank my article on the first page of Google. The article can be found here: The goal is to target 15 specific keywords related to guest posting for 2025, including: 1. Effective guest posting strategies for 2025 2. How to find guest blogging opportunities in 2025 3. Benefits of guest posting for SEO in 2025 4. Top guest blogging sites accepting posts in 2025 5. Guest posting tips to boost website traffic 6. Building authority through guest blogging in 2025 7. Advanced guest posting techniques for link building 8. How to pitch guest blog posts successfully 9. Guest blogging best practices for 2025 10. Measuring ROI from

Are you an experienced graphic designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ec...

More details: What kind of data are you working with? Mixed data What kind of tampering or modifications are you concerned about? Alteration of data values Where is the data stored? Local storage

I need help computing the realized covariance matrix based on daily returns of exchange rates following the same methodology as in a paper (Pricing currency risks, Journal of Finance). I already have a code which does the computation but somehow I don't get the same values (but I get the same shape) [see details in the attached .ipynb file]. I provide all the data needed. Just need someone to go over my code and try to get the correct Covariance Matrices.