based on 2 input values ,- output range of values in separate column

[Benny77]

Hi all .
I am new in the forum and totaly new to excel . Need some some help if posible .

What i am trying to do is to input two values and based on theese values ,- excel should output a range of values in a new row.
In example worksheet i use cells C4 and C5 =AVERAGEIF(A2:A22;A3:A10;B2:B22) . As an example i need excell output values from A3 to A10 ,inputing A3:A10 manualy works great and gives all the values that i need .
The Problem is that i would like to make excel use input values from other cells for example E3:E5 .
And would be able to change data in cells E4 and E5. Based on input values from cells E4 and E5 ,Excel should automaticaly select and return coresponding values .
Not sure that i am using corect formula here . But thats the best i could find . Excel has way to many features for newbies to be aware of .
So please help if you can !
Thanks in advance ROWS (1) (1).xlsx

[TMS]

Try:

Please Login or Register  to view this content.

Change commas to semi-colons.

[Benny77]

Wow that was fast.
Thanks a lot TMS .
Such a simple thing to do but i would newer come up with this myself .
Thanks a lot again mate

[wk9128]

hi Benny77

I don’t understand. What’s your purpose in using AVERAGEIFS? If you want a list, you can use this formula directly.

Please Login or Register  to view this content.

AVERAGE

Please Login or Register  to view this content.

[TMS]

You're welcome.


Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[TMS]

Thanks for the rep.

[Benny77]

Thanks for reply wk9128
I am not an excel user so its the best what i could come up with
Il try your code tomorow .
I would probaly need to split and rearange the data . Dont know if i should open a new thread or can just post in this thread ?

[TMS]

This one

Please Login or Register  to view this content.

produces the same result as your original formula.

[wk9128]

@Benny77 You're Welcome. Glad to help . Thank You for the feedback and rep.

[Benny77]

Alright guys . Provided solution have worked but i need to modify selection and outputdata a bit. At the moment excel is outputing data based on a row numbers.
Is it posible to output data based on information in the cells ?
Lets say i want to output range of data from column A, form 3,25 to -3,25 and coresponding data in that row in column B .
Input data for selection range would be in the cells E9;E10 .
Now theres another problem .
Lets say i put data into cells E9;E10 which would corespond to values of 3 and -3 . But the data in row A would have only value of 3,25 and -3,25.
How can i mak excel choose coresponding values ? I asume the digits can be rounded to full digit, but i would rather use more acurate option if there is one .
Please share your ideas of how can i solve this .
I have reloaded workbook in post 1
Thanks

[TMS]

With 3.25 and -3.25 in the cells E9:E10, you could use:

Please Login or Register  to view this content.

[Benny77]

Works like a charm.
Last question .
How can i put this data into a graph to be axisymetrical in X axis and show all the points from row A ?
If i put values from 10 to -10 i get nice symetrical graph .
But if i put lets say 3 to -3 the graph shifts .
The forum helped me way more than i expected and your input saved me hours of trying to make excell do what i needed .
TMS thank so much.
reloaded the excell file in post 1

[TMS]

Charts aren't really my strength.

But, you have
X-Values: =Sheet1!$A$2:$A$22
Y-Values: =Sheet1!$C$2:$C$22

Not sure that using column C is appropriate but, then, what do I know?

If I set the minimum and maximum X-Axis bounds to 2 and 12 respectively, I get a symmetrical graph.

[Benny77]

The whole point is to input data into rows A and B.
Than based on this data output a chosen range of data into a row C and than plot this data into axisymetrical graph .
Scaling x axis is abit diferent thing.
If someone would add some extra information it would be great .
But Like i said i got more help than i actualy hoped for so i am more than hapy and cant ask for anything more .
Have a nice evening and good start into next week .

[Benny77]

Little update .
I made one more column and used formula provided by member TMS =FILTER(B9:B15,(A9:A15<=E9)*(A9:A15>=E10)) to make a extra row for making symetrical graph.
Thanks thanks thanks !!!

[TMS]

Again, you're welcome. Thanks for the rep.