Find Jobs
Hire Freelancers

Excel Formula Help (Need live assistance now)

£10-20 GBP

Completed
Posted almost 6 years ago

£10-20 GBP

Paid on delivery
I have a cell in excel containing numbers 1 to 90, formatted for example as below 5,68,88 1,75 3,16,68,77 12,34,80 etc I need a formula that will count how many times a cell contains numbers specified, being 1 to 29 and also 1 to 79. These would be presented in 2 new cells as follows based on the above example: 5,68,88 1 2 1,75 1 2 3,16,68,77 2 4 12,34,80 1 2 I need this completed in the next 20-30 minutes please.
Project ID: 17127389

About the project

15 proposals
Remote project
Active 6 yrs 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
Awarded to:
User Avatar
Hi I can send you formula within 15-20 minutes. Should I use this example or you can send me a file?
£11 GBP in 1 day
5.0 (313 reviews)
7.3
7.3
15 freelancers are bidding on average £16 GBP for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with this formula. Please send me a message so that we can discuss more.
£20 GBP in 1 day
4.9 (255 reviews)
7.0
7.0
User Avatar
hi, i understand what u want and i can write formula in 20-30 min, can u please share excel file in chat?
£10 GBP in 1 day
4.9 (116 reviews)
5.8
5.8
User Avatar
Hi, Reading your project description about writing a formula that will count how many times a cell contains specified numbers makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than just show you past similar projects, I want to exceed your expectation by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. Please let my reviews do the talking. Do you want me to start working on the sample right away?
£20 GBP in 1 day
4.6 (27 reviews)
5.2
5.2
User Avatar
let us use team viewer and I will assist you. I am good when it comes to the use of this software excel. Thanks
£18 GBP in 1 day
5.0 (9 reviews)
4.9
4.9
User Avatar
Hi, I am an excel VBA expert and would like to help you with this problem. Please go through my profile and reviews so that you can be confident in my abilities. Surely i can help you in completing this in 30 minutes Hope to chat with you soon Thanks Sajid Khan
£18 GBP in 1 day
4.9 (17 reviews)
4.2
4.2
User Avatar
i can do this, please review my profile and inbox me. i have good command over ms excel especially pivot table, charts, advance formulas etc. Thanks
£18 GBP in 1 day
4.8 (11 reviews)
3.3
3.3
User Avatar
Hi. i am an excel expert and using it since 2009. i can complete your assignment. please share details and also the excel sheet.
£18 GBP in 1 day
4.9 (8 reviews)
3.3
3.3
User Avatar
First split the contents into different columns by using 'text to columns' =SUM(1<A1 and A1<29,1<B1 and B1<29,1 <C1 and C1<29, 1<D1 and D1<29) =SUM(1<A1 and A1<79,1<B1 and B1<79,1 <C1 and C1<79, 1<D1 and D1<79) paste these in E1 and F1 respectively drag them to the bottom to autofill the rest. Hi These are the formulas to use. Best regards, Nabhan
£10 GBP in 0 day
5.0 (9 reviews)
2.4
2.4
User Avatar
i can do this
£23 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I work in excel every day and I suppose, that countifs can help you
£13 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
South Glos, United Kingdom
5.0
3
Payment method verified
Member since Aug 27, 2013

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.