Merge excel files remove duplicate jobs

... etc. Here is an example of what I am needing (not my website, just one I found online). If you can duplicate this page exactly I would be pleased. SPECIAL NOTE ( I only need one page. It must have a product that functions like this one : ==>>The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. If you could duplicate the product on this page exactly as it is, I would be very happy. I do not need the review section on

I would like an edit to remove this gentleman who is sitting next to me from the photo. (I know the lower part of it might not be 100% due to the grate, but I would like that too). In addition to that, the red sign on the left would also like to be removed.

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

...menu for an enhanced user experience 1 - They are not in a hierarchy or in order, how can I put them in a hierarchy and in order? For example I want the site to show top category (continent Europe), when user clicks on that countries (Greece, Germany...) and when user clicks on country then it opens cities (For Germany Frankfurt, Munich, Berlin....) btw it should be duplicated , I need to duplicate and I need to do the same for hotel deals 2 - I want to show this hierarchy and order on top of Navbar as well. I highlighted the place with green. 3 - I want to connect this hierarchy with search box. Whenever they search a city or country, I want all things related to search keyword appear in an hierarchy. 4 - check the website - the design ok but there are some broken parts and...

I'm in need of a skilled Delphi developer who can quickly generate a program that can dive into the registry of a Windows machine and extract the names of all programs listed in the "Add/Remove Programs" section. Key Requirements: - The code should be written in Delphi. - It should effectively scan the registry. - Extracted program names should be displayed in a listbox. This is a simple task, but it's important that the code is efficient and free from bugs.

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I'm looking for a graphic designer to enhance a wellness wheel chart. The chart is currently in PDF format, and I wish for it to be redesigned with a bright and vibrant color scheme. Key requirements include: - Updating the design elements, focusing on a new, vibrant color palette - Remove old text and logo and add new text - Ensure the chart remains clear, visually appealing and easy to read - Incorporate icons or symbols in a strategic way - No interactive elements are needed for this project Ideal candidates will have experience in graphic design, particularly in creating visually appealing and user-friendly charts. Experience in wellness or health-related design would be a plus. A good understanding of color theory and layout design is essential. I can also share a ...

I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial nu...database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I require the cleaning of image history from certain photos. Here's what's needed: • Cleaning image history from various websites including Google Imagery, Yandex, and TinEye. • In the process, the goal is to not only remove unwanted objects from the image but to also enhance its quality and restore any damaged areas. • Expertise in image manipulation, using image editing software, and online reverse image search tools are key for this project. • Previous experience in this particular field would be an asset, hinting a familiarity with the process and promising more efficient results. Remember, attention to detail is key for efficient restoration. Let's clean up the past and provide these images a fresh start!

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

My project involves removing a person from a photo and substitivng that figure with more of the fountain that is in the background of the same image. Here are key details: -The photo is in HEIC format. -The person should be entirely replaced in the image, not just removed. ...fountain already present in the picture's background. The ideal freelancer for this project would be proficient in photo manipulation and editing, with specific experience in manipulating HEIC file formats. A strong sense of aesthetics and detail is crucial to ensure that the inserted fountain looks as natural as possible in the final product. First photo is the one I would like to be edited to remove the man on the right. Second photo has a better picture of the fountain if that could help restore the...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

...(as mentioned in my campaign) Redundancy in my “Visual Arts” profession (due to circumstances unrelated to job performance) that I never could have anticipated has severely reduced the demand for artwork created by the human hand (by artists like me) in favor of computer generated faster/cheaper AI images. The conversion and restoration of old slide images of my artwork using software programs to remove dust, discoloration, etc. is very labor intensive before the artwork image will be ready for digital printing and marketing online which will generate an income from digital prints. I cannot borrow the money we need to fix the roof & stay in business. I have no retirement income; Social Security only counts the last 10 years of employment before you apply for SS b...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

In this engaging task, I'm looking to hire a skilled music producer to merge two songs I have, creating a seamless transition. The desired outcome is a final product that smoothly flows from one song to another, maintaining the integrity and flow of each. Key Responsibilities: - Merging two songs into one cohesive MP3 file - Achieving a seamless transition without disrupting the original tracks Ideal Candidate: - Extensive experience in audio editing, particularly song merging - Proficient in relevant music production software - Creates high-quality MP3 formats - Strong attention to detail to maintain the integrity of the original songs - Evidence of previous similar work would be a significant advantage Please note, there's no need to emphasize any particular sections...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I'm looking for a talented video editor capable of making a less than 5-minute video out of multiple videos. Key Tasks: - Remove certain unnecessary parts from my raw footage - Add effective transitions to enhance the viewing experience and emotional tone as well as music The video is supposed to be about our last year in high school - it needs an emotional ambiance with fitting music Ideal freelancer would have: - Ability to work efficiently within a short time frame

I'm in need of an experienced PHP developer to create a comprehensive web-based portal. This pl...be used by customers to interact with our services. Ensure seamless user experience and accessibility. - Employees: Employees should have access to specific tools and information. Develop an interface that is intuitive and geared towards productivity. - Administrators: The administrators should have full control over the content displayed on the portal. They should be able to upload, edit, and remove text and image content. Ideal candidates for this project should have: - Proficient in PHP development - Experience in creating user authentication systems - Strong understanding of CMS development - Prior experience in developing web portals is a big plus Looking forward to seeing ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

...process payments. When I bill a client Stripe processes the payment the client makes. Starting in October of 2023 Stripe placed a RESERVES on my account that holds 35% of all payments for 90 days. There reasoning behind this didn't make sense. They said it was because I was high risk for disputes and chargebacks yet I hadn't had any of those for a year. Once I explained my business they would remove the reserve after a couple weeks.. Meanwhile my business came to a halt because that 35% is essential for my business to operate smoothly. the past 6 months they have placed and removed a Reserve on my client payments which has severely disrupted my business operations. I could start jobs, I lost contracts because of that. my business almost went under. This is all...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

Hello, I need complet the Amazon categories catalogue excel in french

I'm in need of a proficient artisan to rejuvenate the painted design on a wooden footstool, which is in good shape. Attempting to preserve the existing design, I seek out someone who can expertly duplicate and revive the same pattern and color palette. Attached picture is what it should look like. Much of that design is missing and faded with use on my footstool. YOUR TASKS WILL INCLUDE: - Careful examination of the existing design - Duplication and restoration of the original pattern - Selection of appropriate colors matching the existing ones REQUIRED EXPERIENCE AND SKILLS: - Track record in fine arts, particularly in painting and restoration - A keen eye for detail to accurately replicate the existent design - Experience in working with wooden surfaces and its particula...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I am in need of a professional photoshop artist to remove specific elements from the background of my photos. These elements include: - Parking lot - Outhouse - Sign Once removed, these elements need to be seamlessly replaced to match the rest of the nature in the photo. The ultimate goal is to make the edited areas indistinguishable from the rest of the background. The desired resolution for the edited photos should simply match the existing resolution of the original photos. Ideal candidates would have a strong proficiency in photoshop, with particular experience in photo manipulation and retouching. A keen eye for detail and an understanding of natural light and shadow are also advantageous. There are 30 photos total and they are all very similar.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm using the payment gateway plugin called 'MercadoPago' on my WooCommerce store. I need to duplicate this plugin to be able to use it for both Colombia and Mexico. Currently, the plugin is configured for any country by entering the corresponding API Key and API Secret. However, WooCommerce doesn't allow having two identical plugins installed. I will provide the functional plugin, and you will make the necessary changes within the plugin so that Woocommerce does not detect it as a duplicate plugin, and does not have compatibility problems with the original plugin

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I kindly ask for payment that I did up to here: - Inspect the code and remove Invisible mode section on profile page for mobile and desktop theme - Enable/fix youtube video's sound for desktop version of script

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I need a master of Photoshop to expertly remove an object that is centrally placed in my photo. The object to be removed is distinctly separate, none of the elements in the image overlap or intertwine with it. The ideal freelancer for this project should possess: - Exceptional Photoshop skills, particularly in object removal - Keen eye for detail to maintain the integrity of the remaining elements - Experience in image manipulation and restoration projects. Your goal is to make the final image look as natural as possible, as if the object was never there to begin with. Efficiency and promptness is appreciated.

I need a professional who can effectively record three of our management meetings for review and analysis purposes. Key Details: - The meetings are expected to continue for three days each. - All mee...meeting and conference settings. - Strong attention to detail and professionalism. - Fast and efficient, without compromising the quality. - Excellent time management skills. - Ability to handle unforeseen recording challenges that may arise. - Familiar with different audio formats and compression settings, to deliver the final product in the desired format. - Understanding of audio editing, to remove unwanted disturbances if needed. Please include samples of previous recordings in your proposal. Your understanding of the project needs and your approach to it will be a decidi...

I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints

...shopping experience. Key requirements: - The website should have a visually appealing and user-friendly design, with a clear focus on the products. - The primary goal of the site will be to facilitate online sales, so it's essential that the developer has experience in creating successful e-commerce platforms. - It's crucial that the site supports a shopping cart feature, enabling customers to add, remove, and manage their selected products easily. - Customer reviews play a significant role in building trust and credibility. The site must include a review system for customers to share their opinions on the products. - A secure and reliable payment gateway integration is essential. The developer should have prior experience with different payment methods and be able to ...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...provide the necessary information for new team members. You'll be responsible for ensuring their details are accurately added to the roster. - Updating Existing Team Members: There may be changes to the current team members' details (e.g. position, contact information, etc.). You'll be updating these details accordingly. - Removing Team Members: As we continue to evolve, there may be a need to remove certain team members. You'll be responsible for removing them from the roster. Ideal Skills: - Strong attention to detail: Considering the sensitivity of the data, it's important that all changes are made accurately and promptly. - Proficiency with data management: A good understanding of data management principles will be valuable in this role. - Excellent ...