Hi all,
I am a bit new to excel and was trying to set something up, but I'm not sure if it is possible. Its a bit difficult to explain what I want to do, so I set up a sort of an example in an excel sheet. Its a bit complicated and I apologize if its absolutely stupid. But if it is possible I would appreciate any help. I also realize it may take some work, so if anyone could just point me in the right direction of functions I would be quite happy also.
Thanks for any help.
Jammy :puzzled:
I've been reading over some other posts and I think I may be able to clarify what I'm looking to do. I am trying to figure out if there is a function that finds range as its answer as opposed to a single number. For instance I have data set of 4 columns(A,B,C,D). I want to find the range where the sum in column D is equal to or greater than x, starting from period y(in column A). So I want to be able find the range by inputting 2 variables.
Secondly, once I find this range is there any way to have excel find the max and min data figure in columns B and C based on range found in first question. I am currently doing all this by hand and its quite annoying. Is there any way to automate this so that all I have to do is input the first 2 variables? Thanks for any help.
OK, let's take this stpe by step.
First issue:
you've got a column of numbers & a column of periods. I understand you to want something like the following:
Starting from period X, where X is a variable set somewhere else in the sheet, sum column D until the sum matches Y, a threshold value also specified elsewhere.
If this is right, you need to furter specify the problem. We need to know, for example:
1) What happens if the sum of the remaining values does not equal the threshold
2) Are you looking for the sum that is nearest to, but not greater than, the threshold? nearest to but not less than the threshold value? If just 'nearest', what would happen when the threshold is equidistant between the nearest sums greater & less than etc....
Further specifications please.
Hi Paddy,
Yes your interpretation of my problem is correct. To clarify, I am searching for the sum closest to being equal to or greater then variable y. What is a bit different for me is that I would like the answer to above to be the range (x-?) as opposed to the sum that comes closest to y.
Secondly, I would like for the range to be used to find the min and max data points in 2 other columns but based on range found in first question.
I am currently using a simply sum function from the period which I select and then copy out that range of data to find the min and max data points. Basically doing it all by hand. Quite time consuming. Which is why I'm trying to figure out if I could automate it to where all I need to input is x and y. Thanks for the response.
Jammy;)
Don’t have an account yet? Register yourself now and be a part of our community!
