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.
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?
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
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