Formula/Array in Excel 2013
$10-30 AUD
Paid on delivery
I need a formula for a small problem.
I have a series of numbers that i need to identify firstly as an integer and then count the frequency of unique integers in the series.
To give you some examples...
39.1
39.4
39.5
40
41
the count of integers would be 3 as when the numbers are turned into whole numbers the series is as follows: 39, 39, 39, 40, 41 so there are 3 unique integers.
To give another example...
34.6
34.9
40.5
40.1
33.9
the count of integers would be 3 as the series would be 34, 34, 40, 40, 33 and there would be 3 unique integers.
It is important that this is a formula/array in a cell and NOT a VBA soultion.
Happy to discuss.
in the process of developing the correct answer i do not want another table created
Project ID: #11958825
About the project
24 freelancers are bidding on average $21 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More
Pleasure to help you excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
Hi, I am an accountant and an excel expert. I will be able to do this if I am allowed to add two columns next to the numbers. I have tested the formulas and this works. can send you a sample of required. the only cond More
Hi Sir, I can give you formula to count the unique integers in cells. Message me to start. -- Thanks Rajesh
Hi, Please give me a chance to work on this project as I have hands on experience and relevant knowledge too. Thank you.
I am very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and Excel. I believe my skills would be ideal for your project. I can complete this j More
I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me in all the factors in your project. i promise to give More
Hello! I am an Excel expert. I have more than seven years experience in any kind of Excel works. I am very interested to do your offered job now. You can check my 'Learning Record' and ‘Portfolio's Sample work sheets.’ More
What am better? Nothing makes me better than others. I can only say that I have free time, which is nice to utilize is making money. Apply for projects that I think I can do it!
I am expert in data entry. I have also worked on MS office and in different sheets .I am punctual and hard work man .My aim is provide good work with in time and keep employ happy with minimum charges. I will do work a More