Excel combine rows with same value jobs

I'm seeking a proficient freelancer to assist in a straig...proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficient...

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportun...

...am aiming to have a pi zero programmed to read voltage levels from a 12-volt battery bank. The trigger to start the generator should be a low voltage condition. The purpose of this project is to remotely start the generator, with a focus on maintaining efficiency and practicality through a direct physical connection. Key objectives include: - Programming the pi zero to accurately gauge low voltage conditions - Enabling the generator to automatically power up in case of a drop in voltage. - Continuing the generator input even after the voltage returns to normal, with this feature designed to maintain a steady and reliable power supply. Ideal Freelancer Skills: - In-depth understanding of Raspberry Pi Zero programming for hardware operations - Knowledge in direct physic...

...of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria: General appearance and manufacturability of parts Quality and cleanliness of part modeling and construction trees Accurate assembly definition and kinematic mobility Definition of stops...

I am looking for a skilled graphic designer to assist with the rebranding of my company, PumpSpec, along with its divisions R&D Pumps & Power, National Mining & Civil Solutions, , and Thinkwater Fleurieu. The primary goal is to create a cohesive and modern visual identity that reflects our businesses. Key deliverables include: - Design of letterheads and business cards for each division, aligned with the new visual identity - Incorporating the chosen color scheme of Black and Blue, with the option to add other complementary colors - Inclusion of essential information on the stationery such as company name, address, phone number, website and email address, logo and tagline we want all businesses to be on the footer The desired design style should ...

I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessary skil...

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formattin...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I need an Excel expert to enter a set of numbers and dates into an Excel sheet, and perform some basic calculations. - Data Typing: You'll need to be comfortable working with both numbers and dates, as these will be the primary data types that need to be entered into the sheet. - Calculations: There are two specific calculations that need to be performed on the numbers: - Summation: You will need to calculate the total of all the numbers. - Average Calculation: You will also need to find the average of all the numbers. - Date Formatting: The dates I will provide need to be formatted in both date and time format. This means you should be adept at formatting cells in Excel to ensure the correct display of dates and times. Ideal Candidate: - Proficie...

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appealing, modern designs that align with our brand is crucial. - Functionality Enhancements: There are certain functionalities within the project that need to be revisited and improved. Your role will involve identifying areas for enhancement, suggesting necessary changes, and implementing these updates effectively. You should be well-versed in PHP development and capable of optimizing exist...

...artist to paint a medium-sized nursery wall mural with a beautiful floral design. It should consist largely of giant flowers, stems and leaves, not necessarily overlapping each other. The color scheme should encompass various hues of sage greens and dusty rose colors, bringing a natural, soft, yet vibrant feel to the space. The ideal candidate should: - Have prior experience in painting wall murals, and have a portfolio to demonstrate their previous artistic projects. - Have a keen understanding of mixing colors to achieve the desired feel. - Operate with professionalism and timeliness, ensuring the project is completed in a timely manner without compromising on quality. Your attention to detail and passion for your craft will add value to this project and tra...

...to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience working with PHP, particular...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionab...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and cha...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

business profit loss reporting excel(Jan, Feb & March)

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...

...agency, I'm seeking a professional with a strong background in business development and sales to help achieve specific goals: - Increasing Sales Revenue: Your main responsibility is to explore strategies and execute plans that result in significant sales growth. - Expanding Customer Base: I'm particularly interested in reaching out to small businesses. I need someone who has a deep understanding of this segment and knows how to communicate the value of our services effectively. Ideal Skills/Experience: - Proven experience in business development, ideally within a marketing agency - Strong track record in increasing revenue - Demonstrable success in attracting small businesses - Excellent communication and presentation abilities - Highly motivated, with...

...what sort of concept people can come up with. Please follow the same concept as the EyeVantage logo. Key Points: - Logo Revamp: The main reason for this redesign is rebranding, I need the logo to reflect my new brand identity and messaging. - Modern & Minimalist Style: The new logo should be "Modern & Minimalist", so I'm keen on a design that is sleek, clean and contemporary. - Specific Colors: I do have specific colors in mind for my new logo, which I will provide during our discussions. Ideal Experience: - Proven experience in logo design, with a strong portfolio that includes modern and minimalist logos. - Understanding of branding and the ability to translate a brand's essence into a visual identity. - Strong communication skills,...

I am desperately seeking a skilled digital artist who can recreate less than ten of my wedding photos which were tragically lost 50 years ago. Your contribution will help me greatly in preserving cherished memories which are of high sentimental value. To be the perfect fit, you should: - Be adept at digital art and photo editing. - Understand and capture the grace and elegance of a bygone era. - Have an innate ability to recreate photos from descriptions and reminiscent feelings. Your task will stretch beyond just photo recreation. It's about breathing life into lost memories, and creating timeless keepsakes which will be cherished for generations.

Please Sign Up or Login to see details.

...requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the addition of a new category search criterion using the Smyles Plugin on the back-end. - Ensuring a smooth integration: You must make sure that all changes and additions are fully integrated with the existing system without causing any...

I am seeking a skilled and experienced home designer to help me in enhancing the functionality of my home. My primary goal is to make a modern home design for outdoor and indoor Key Features: - outdoor design including home front , Backyard, walls and garden - indoor (Duplex indoor design) Ideal Skills: - Proficiency in home design and landscaping - Experience in creating fu...functional and aesthetically pleasing outdoor living spaces - Knowledge of pool, kitchen, and fire pit design and installation - Excellent communication skills to understand my vision and provide creative input The successful freelancer will be one who can bring creative ideas and a practical approach to the project, ensuring the end result is a beautiful, functional home that adds significant value to my...

I'm in need of a skilled high-ticket closer for the launch and scale of my new Info Product, a Home Services based ...high-ticket sales. Key Responsibilities: - Collaborate on the development of sales strategies for the Home Services program - Conduct sales calls and negotiations with potential clients - Close high-value deals in the Home Services industry Ideal Skills and Experience: - Proven experience as a high-ticket closer in the US market - In-depth knowledge of the Home Services industry - Excellent communication and negotiation skills - Experience in launching and scaling of info products is a plus If you are a US-based high-ticket closer with a keen understanding of the Home Services industry and a successful track record in closing high-value d...

...general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a good underst...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

...need any experience whatsoever, but you must be clever and eager to learn. No. I am *not* being charitable; rather, I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will be an unpaid logic test. In other words, I would not pay you any money whatsoever if you were to pass the...

Hi VJ IT Services, combine like last time, Data sheet has main data and secondary data (if you cant find a name)

...Description: We are seeking a talented and creative graphic design team to create a professional and visually appealing pamphlet. This pamphlet will be used to showcase the various service plans and benefits offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and readability. Content Integration: Use the provided content from our three service plans (Basic Care Plan, Enhance...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for ...

I'm in need of a talented freelancer to assist with content creation. This project is focused on boosting brand awareness and making our products and services more visible to potential customers. Key Responsibilities: - Conceptualize and create compelling content that resonates with our target audience. - Develop engaging written content or video content that clearly communicates our brand message and value proposition. - Ensure that all content aligns with our brand guidelines and voice. Ideal skills and experience: - Proven track record in content creation, preferably with a focus on brand awareness. - Strong writing and/or video production skills. - Ability to understand and effectively communicate brand values. - Experience in a similar project...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19....

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

...facing a small-scale project that requires the transfer of 200 ebooks from a Sony e-reader to a Kobo e-reader. Handling this many files can be a challenge for an untrained person, and I need an expert on my team. The project requires: - Knowledge and understanding of Kobo E-readers and Sony E-readers - Familiarity with E-book file formats - Able to deliver a precisely organized outcome Handling this quantity of files is no minor task, so I will place high value on the following skills: - Excellent organizational skills to ensure the easy location of each ebook post-transfer. - An understanding of ebook cataloging - managing metadata may become essential - Problem-solving skills, should any issues arise during the transfer process If you can ensure a sm...

...searching for a talented graphic designer to work with on a long-term basis, contributing to various projects for my team. The ideal candidate will have the following qualities: - **Experience:** I require someone who has a solid background in graphic design, with a proven track record of successful projects. Your experience should cover a range of graphic design areas, ideally with a specialization in modern and minimalistic styles. - **Creativity:** I need a designer with a knack for generating innovative ideas. A strong creative vision will be a key asset. - **Portfolio:** Please be ready to showcase your portfolio, along with your previous works. This will help me understand your style and experience better. - **Communication:** I value...

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

...company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points efficiently. ...

...seeking a professional with extensive experience in structural engineering, especially older homes. My property is an 1890s house in Michigan requiring structure optimization for joist, rafter, and beam/collar tie to better withstand our moderate winters. Unknown to me is whether or not the house currently has issues. However, when I opened up to see the framing, I discovered both damaged or rotted wood, and what appears to be inadequate support or bracing. The ideal freelancer for this job should: - Be highly knowledgeable about structural engineering, especially for older constructions. - Have extensive experience with the assessment and treatment of damaged/rotten wood. - Be capable of designing and implementing robust structural supports. Being familiar with...

...how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project brings to the market and why it's a worthwhile investment. In terms of the length, I'm looking for something between 5-10 slides - it should be long enough to be comprehensive, but succinct enough to hold the attention of potential investors. Ideal candidates should have: - Proven experience in creating successful pitch decks that have secured fund...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...

I want a strategy for tradingview that it opens the orders manually or crossing emas, we input a range for the stop loss and take profit using % or $ and when it reachs the SL it opens a new order using the same range and different direction, if it is long, turn in to a short but with the value increase by a pre set multiplier (one for the SL ad one for the TP) and also add a possibility to multiples TP We also need to pre set a limit of times that the reversion happens and also add a option tralling stop loss. Can you make it?

...sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. I...

I'm looking for an experienced domain broker to assist with selling a high-value domain in the technology industry. Key Points: - **Domain Expertise**: Familiarity with the technology niche is crucial. Understanding of the potential buyers and market, as well as the ability to articulate the domain's value. - **Negotiation Skills**: Proven ability to negotiate and secure high-value sales. Past experience in selling high-end domains would be a significant advantage. - **Professional Network**: A well-established network in the tech industry, particularly among potential domain buyers, would be highly beneficial. - **Confidentiality**: Ensuring all transactions are handled with the utmost discretion and confidentiality. I have a target p...