Excel combining delete duplicates työt
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save to a f...
I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
...that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong kno...
I need assistance with ex...need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel...
...highly proficient individual to assist me with several key tasks. 8am - 5pm PST availability, full time role. Key Responsibilities: - Data Analysis: You should be able to dissect and interpret a variety of data sets, particularly surrounding sales, leads, and conversion rates. - Report Generation: Using Excel or Google Sheets, you will be responsible for creating detailed reports on sales performance, lead generation, and conversion rates. Ideal Skills and Experience: - Fluency in Excel/Google Sheets - Previous experience working as an executive or virtual assistant for sales managers or VP of sales, ensuring you understand the requirements and demands of the role - Exceptional attention to detail and a track record of maintaining high standards If you feel you have the...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skilled in Excel, a...
I'm seeking an experienced street photographer in Katmandu. I wish to capture the essence and vibrancy of the city in a unique and colorful way. Key requirements: - The photographer must be skilled in capturing the life and character of distinct locations such as Thamel, Durbar Square, and Boudhanath Stupa. - The style should be a blend ...vibrant and colorful shots along with elegant black and white compositions. Ideal skills and experience for this project: - Proven experience in street photography, ideally in an urban setting - Ability to capture moments naturally and candidly - Strong post-processing skills, especially in creating vibrant and appealing images - Previous work in black and white photography would be a plus, combining with color shots to create a visually ...
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The...
...with such a size (but many parts from the can be found in them as well) the coding-style is comparable to the additionally, there are about 20-30 pages with about 20kb - they are much simpler (eg JQuery DataTables with Queries to fill these tables) plus another ~60 .php files for queries or for performing little sub-features based on these queries (big amount of duplicates due to my procedural-functional "coding style" that is often more like drawing the pages instead of coding them ... for a skilled developer, many of these php-files will likely become obsolete and code can be referenced instead of being copy `n pasted for reusing it... ... feel free to check the other pages as well - the app is running via docker / docker-compose and a README for s...
I'm looking for a seasoned graphic designer to help me create an abstract crypto logo inspired by aspects of artificial intelligence. Key elements should represent neural networks and machine learning. More specifically: - The logo design should be abstract and sophist...The logo design should be abstract and sophisticated, echoing the complexity of AI. - A monochromatic color scheme is preferred to maintain a professional and refined aesthetic. The ideal candidate for this job is someone with: - Extensive experience in abstract graphic design - Deep understanding of AI concepts and how to visually represent them - Skilled in creating monochrome logo designs Combining these elements, the goal is to reflect the cutting-edge technology underlying cryptocurrency and artificia...
Certainly! Here are the key traits and characteristics of a successful salesperson or sales representative: 1. **Communication Skills**: A good sales professional possesses excellent verbal and written communication skills....effectively and meet deadlines. 8. **Flexibility and Adaptability**: The sales environment can change rapidly. Effective sales professionals can adapt to new situations and challenges, responding flexibly to customer needs. 9. **Resilience**: Sales can involve facing rejection and setbacks. A successful salesperson views these as opportunities to learn and persist towards achieving their goals. Combining these skills and characteristics enables a sales professional to engage customers effectively, build relationships, and ultimately drive business growth an...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...
I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and ca...
...setup within Wordpress is a must. - Sales Funnels Creation: I need a sales funnel that converts effectively. Your previous experience in creating and implementing high-performing funnels is highly desirable. specifically: 1. WEBSITE HAS BEEN LAID OUT, NEED TO FINISH IT 2. SET UP REGISTRATION QUESTIONS AND PAYMENTS (WOULD LIKE TO OFFER ACH PMT OPTION ALSO) 3. FUNNEL REGISTRATION QUESTIONS TO AN EXCEL REPORT TO USE FOR MAIL MERGE DOCS TO PRINT CUSTOMIZED ITEMS (***FIRST CHOICE IS THAT THE MAIL MERGE BE AUTOMATED ALSO!!!***) 4. AFTER ATTENDEE REGISTERS: a. POP UP ASKING TO COMPLETE PRE-RETREAT SURVEY b. WELCOME EMAIL WITH DETAILS IS SENT c. CALENDAR INVITE IS SENT (IF LIVE DEI) have welcome video attached d. NOTIFICATION IS SENT TO ME, MY ASSISTANT, AND POSSIBLY VENDORS (INITIATI...
I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames...unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experienc...
...method for carrying out this process. Requirement: Create a plugin that allows for the automatic synchronization of the inventory of products loaded in Shopify along with their properties Properties include taxonomies, brands, departments, keywords, categories, subcategories, price, among others. Automatically update the stock of a product when there is movement in Shopify or our current ecommerce. Delete products that have been removed from the Shopify catalog. Initial Setup For the integration of the plugin between Shopify and our current ecommerce API, it is required that the Shopify dashboard allows the configuration of credentials such as the Token ID and Secret Key. After the initial setup, it is necessary to carry out the synchronization of the taxonomies, covering ...
...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...
Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.
Wanted: Full Stack Developer We are a digital agency specializing in assisting start-ups and organizations with discovering, developing, and launching their next digital projects. By combining strategy, design, and technology, we transform businesses and realize their digital ambitions together. We are a small, tight-knit team consisting of three colleagues, supplemented by a flexible pool of freelancers. We are now looking for a permanent addition to our team. If you share the same passion for delighting numerous clients by creating pixel-perfect designs and interactions, then you're in the right place! What will you do? As a full stack developer, you will be responsible for translating designs into user-friendly websites or applications. You will do this using the latest te...
I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I am seeking a skilled developer to redesign the user interface of my Open Cart platform. The new UI should be crafted with a professional and corporate aesthetic in mind, combining style with functionality. Key Requirements: - Redesign the user interface of the Open Cart platform to provide a professional and corporate look - Ensure the new design is not only visually appealing but also enhances user experience and functionality The ideal candidate for this project should have: - Proven experience in UI/UX design within E-commerce platforms, specifically Open Cart - A strong portfolio demonstrating a professional and corporate design style - An understanding of user experience principles and best practices in E-commerce Please share your portfolio showcasing similar projects you...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I am looking for a skilled freelance designer to create a minimalist logo that focuses on establishing strong brand recognition. The design should incorporate neutral colors, combining simplicity and clarity to convey a strong brand message. - Desired Design Style: Minimalist - Preferences Color Palette: Neutrals - Main Purpose of the Logo: Brand Recognition The ideal candidate should have strong skills and experience in minimalist design. Their expertise should extend to color psychology, understanding the importance of neutral tones in emphasizing brand identity. Proven experience with brand development would be beneficial - please provide relevant portfolio examples in your bid. The ability to accurately convey a brand's essence using minimal design elements is paramount....
As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi concrete market, one data point at a time!
I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.
I am looking for a proficient C++ developer ...can simplify the openDTU projekt so that I will have only the inverter control functionality without all the other protocols. I want to be able to control the inverter with the ESP32 directly. over the nrf24l01+ module. The Projekt is found at: The OpenDTU is a DTU which enables control of multiple different solar inverters. The Projekt uses a web app to add/delete inverters and show or control the values which the solar panels are producing. I want to use the inverter control functionality inside of my own project so that I need library where I have the same features than in the web app but controled in my own code. So the task is to simplify the openDTU project for just the inverter control functionality.
I need a big team who can process a huge lot of images... I have collected 30k recipe images and now the data size is too big so I need you to delete useless images and rename ONLY 1 image per folder. the work is effortless but MANUAL WORK Step 1 - Download and extract systematically from ZIP Step 2- Delete (80%) + Rename (only 1) Step 3- Upload the data back in ZIP to drive. BID PER 500 FOLDER Total folders = 30,000 current images per folder = 40-80 Images to keep per folder = 10-14 Expected team size needed = 10-50 people (I have 12-14 days total) Only reliable and serious candidates should apply
Preciso transportar dados de uma pesquisa do google formulário para gráficos gerados em Excel, para serem adicionados em trabalho acadêmico.
I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.
As the developer for this project, I will write a RESTful service in Java for tracking timecards. My main purpose is to let the company record employee working hours, generate payroll reports, and monitor employee attendance. To do this, my service must include the following functionalities: - PUT: Create a new timecard - POST: Update an existing timecard - DELETE: Delete an existing timecard - GET: Retrieve timecard information All the aforementioned tasks will return a JSON string, either formatted or unformatted. The JSON string format will not strictly be enforced in this RESTful service, as the main focus is providing a swift and reliable way for the timecard data to be manipulated and retrieved. The successful freelancer for this post should have excellent Java pro...
I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.
I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the abil...
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
...nutrition info for all those ingredients from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate file. Outcomes - 1. My Excel files - with names replaced with ID (non-duplicate) 2. 1 New file ie...
I'm looking for a skilled React developer to enhance an existing application that allows users to draw rectangles on PDF files. Responsibilities: - Implement the ability to resize rectangles using a slider. This will enhance the current user experience and make the application more intuitive. - Add functionality to select multiple rectangles and delete them at once. This feature will improve efficiency and save users time. Ideal skills and experience: - Proficiency in React: as the modifications are to be made in a React application, a strong understanding of React is essential. - Experience with PDF manipulation in React: to ensure the correct implementation and smooth functioning of the new features. - UI/UX design: to ensure the new functionality is integrated seamlessly a...
I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this task. They...
...an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past work as well as your experience in the field. This will assure me of...
...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experi...
Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab
