Find Jobs
Hire Freelancers

Excel Sheet -format

$30-45 USD

Closed
Posted 5 months ago

$30-45 USD

Paid on delivery
I am looking for a freelancer who can help me format an Excel sheet that includes both numerical and textual data. we have an excel sheet with 15 columns, and approx 1000 lines. TASK 1. In 1 column, for every line we have a letter Y or a letter N, first I want to remove all the lines with a letter N. TASK 2. In 1 column, for every line we have the business name, so next I want to group the lines together so all the lines with the same business address are grouped together. Possibly having a blank line above and below the group (If there is a business with just 1 line entry, then that will be a group of 1). TASK 3. In 1 column, for every line we have a date, once we have the lines grouped by business name, i want them in date order so the line in the group with the oldest date shows first.
Project ID: 37582868

About the project

379 proposals
Remote project
Active 4 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
379 freelancers are bidding on average $44 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$45 USD in 1 day
4.9 (570 reviews)
8.5
8.5
User Avatar
Hi, I can help you to format an Excel sheet that includes both numerical and textual data. I am a top-rated freelancer in Freelancer.com. Data entry job is my passion and I have 7+ years of experience in this field. I’ve worked on several similar projects including web scraping, web search, excel formulation and shopify product listing. You may see my profile here: Freelancer.com: https://www.freelancer.com/u/motiur03.html I have completed over 700 projects on freelancer.com and have extensive knowledge and experience in similar jobs, so I can handle this project accurately. Message me so we can discuss more. Best Regards Motiur
$40 USD in 3 days
4.9 (291 reviews)
7.9
7.9
User Avatar
Hi, I can do this project right now with 100% accuracy. If you need any sample please let me know. Thanks
$45 USD in 1 day
5.0 (417 reviews)
7.8
7.8
User Avatar
Hello! My name is Waseem and I am a highly skilled and acclaimed freelancer on Freelancer.com with over 10 years of experience in data processing, Excel, Word and Access databases. I have received certifications from ALISON for Microsoft Office specifically Excel and Formula, Word and Access Database which confirms my proficiency in these applications. I am confident that I can deliver outstanding services to help you format your Excel sheet that includes both numerical and textual data. With my expertise in data processing, I am able to efficiently undertake tasks such as in TASK 1 where I can remove all the lines with letter N from the spreadsheet in one column while grouping lines with the same business address together so they are not visible above or below other groups.
$30 USD in 1 day
5.0 (322 reviews)
7.3
7.3
User Avatar
"""""""""""""""""""""""""""""""""""ADVANCE EXCEL EXPERT"""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$45 USD in 1 day
4.9 (281 reviews)
7.4
7.4
User Avatar
Hello, I can help sort and organize your Excel spreadsheet based on your needs. I have extensive experience with similar projects, including approximately 250 previous ones. You can find some examples of my work at the following links: https://www.freelancer.com/projects/excel/Need-very-experienced-Excel-expert https://www.freelancer.com/projects/data-entry/Generate-phone-number-list https://www.freelancer.com/projects/excel/Excel-expert-33829779 https://www.freelancer.com/projects/excel/need-someone-complete-Excel-spreadsheet https://www.freelancer.com/projects/excel/Excel-Spreadsheet-order-list-Number https://www.freelancer.com/projects/excel/Extract-multiple-URLs-from-text https://www.freelancer.com/projects/data-entry/Spreadsheet-Sorting-wood-into-widths https://www.freelancer.com/projects/excel/create-excel-formula-31735012 I'm all set and ready to get started. My time zone is GMT+7, which means I am 7 hours ahead. If you are interested, please feel free to send me a private message. Best regards, Hoang
$45 USD in 2 days
5.0 (174 reviews)
7.2
7.2
User Avatar
I can help you to format an Excel sheet that includes both numerical and textual data. Task 1: I know in column 1 you have the letter Y or Letter N, I will remove all the lines with the Letter N. Task 2:For every line has a business name, so you want to group the lines that have the same business address, If you have a blank line then we have to group it separately. Task 3: For every row that has a date on it, you want it group it business name with the date order with the oldest date shown first. I’ve completed lots of projects related to Excel spreadsheets, and can assure you that you’ll get the project file with 100% accuracy. If you’re interested in seeing the quality of my services then feel free to visit my profile: https://www.freelancer.pk/u/saqibabbasi01993 Looking forward to a cheerful response. Thanks SK
$45 USD in 1 day
5.0 (315 reviews)
6.9
6.9
User Avatar
Dear sir/madam, I checked and understood. Please message to me. So, I can show sample right now for your approval. Thank you so much. Cheers! :=)
$30 USD in 1 day
5.0 (148 reviews)
6.9
6.9
User Avatar
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
$45 USD in 1 day
4.9 (133 reviews)
6.7
6.7
User Avatar
Hi! I am full time freelancer and good in excel, I can do this work right now, I can assure you for quality, Looking forward to your positive response. Thanks.
$30 USD in 1 day
5.0 (180 reviews)
6.8
6.8
User Avatar
Hi, I am a skilled Excel professional from Vietnam with 10+ years of experience. I can help you format and clean your Excel sheet accurately and efficiently. I am available online most of the time and respond to messages within 12-24 hours. How can I help you with your Excel task? Best regards, Duong
$30 USD in 2 days
4.9 (82 reviews)
6.6
6.6
User Avatar
Hi There, Ready right now I'm ready to format an Excel sheet that includes both numerical and textual data. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer
$30 USD in 1 day
4.7 (168 reviews)
6.3
6.3
User Avatar
Hello Sir, I will help you in format data according to your requirements i can show free samples if you want can you message me so that we can discuss i have completed 117+ projects in freelancer i am available now contact me for a free sample I trust my abilities and skills. So you can hire me for the project. Thanks Jay Khanna
$30 USD in 1 day
4.9 (98 reviews)
6.2
6.2
User Avatar
Hello, I've read your job description very carefully and I understand what you described. I'll charge 35$ and a maximum of 1 day to make it done. I'd love to see the file and discuss it with you. Can you pls send me the file so that I can see. Thank you.
$35 USD in 7 days
5.0 (22 reviews)
6.0
6.0
User Avatar
Hello I am engineer in Statistics ، i have a good experience in data analysis and excel ,i can help you asap Regards
$38 USD in 7 days
5.0 (61 reviews)
5.9
5.9
User Avatar
Hi, Ready to start work ASAP......... expert in data excel sheet work...... I am expert in and ready to start work on this project and deliver you quality of work with 100℅ accuracy.. am very confident to do this work in better way...Message me so we can discuss and start the work.. Thanks
$30 USD in 1 day
4.8 (107 reviews)
5.6
5.6
User Avatar
Hello Sir, Merry Xmas I went thru the description I have done projects with data cleansing, I can send sample details to you This task can be started RIGHT NOW and before you award the project I can do some extent to show you I am on the right track I look forward to hearing from you thanks regards Thushara
$50 USD in 2 days
5.0 (39 reviews)
5.3
5.3
User Avatar
Hi, I'm ready to assist with formatting your Excel sheet to meet your specifications. I've understood the tasks and can start right away. With a background in Excel and data manipulation, I've successfully handled similar projects, ensuring accuracy and adherence to client specifications. I'm ready to dive into this project and deliver results promptly. Looking forward to making your Excel sheet organized and easy to navigate! Best regards, Natalija
$50 USD in 1 day
5.0 (4 reviews)
5.4
5.4
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$35 USD in 3 days
5.0 (42 reviews)
5.4
5.4
User Avatar
Hello sir, Plz ping me once... I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m an efficient and experienced data entry worker. If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project. Regards Ruchi Agarwal
$30 USD in 1 day
5.0 (62 reviews)
5.5
5.5

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
150
Payment method verified
Member since Apr 9, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.