Find cells within range equal to 70% of sum of total range
Hi everyone,
New to the site and a beginner with VBA. I have told someone at work i will help them sort out a spreadsheet problem but I am struggling(I need to keep this job so I agreed!!). They input new data into a spreadsheet each day and have to from that range find the sum of the data. They then find the value of 70% of this sum. From the maximum value in the range they then count one cell up, one cell down starting with the larger each time adding to the max value until it reaches the 70% of total figure.
I have tried endlessly with if functions and sumifs, and every other formula i could imagine without success. I have tried using percentiles too but it selects highest value numbers not those directly one cell up or down without leaving a gap in the range.
Someone suggested VBA would work and I have been reading books on how to do this but i do not know where to start. If someone could even get me started it would be much appreciated. Attached is an example of what I am trying to achieve.
I hope you guy's can help as this is something I want to learn and develop some skills in, unfortunately this project I am a bit rushed on time.
Reply With Quote