Find all values which meet specific conditions

[ProFromMars]

Hi everyone!
I am having a rather hard time with my home-made database. Basically, I am looking for a function / program / formula that can find the values which meet specific conditions from database. Let me give you a little example:
I will manually insert deviation range into excel, for example 99 and 101. Now what I want the Excel to do for me is that it should search and get all the values from database between given deviation range aka 99≤X≤101.
The database is just punch of different numbers in one column.

I appreciate your help

[FDibbins]

Hi, welcome to the forum

And what do you want excel to do with the data/matches it finds? Extract? Count? Sum? Average?

I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[ProFromMars]

Thank you for a quick response!

I want Excel to extract the data it finds. I added an example as an attachment, I hope it is understandable.

[southward]

Hi,

Here is the array formula, enter with CTRL+SHIFT+ENTER.

Please Login or Register  to view this content.

In order to be able to copy down and across, you need to truncate your Name/Deviation Range array.

Maybe there is a Guru out there that can modify this formula so you don't have to truncate your Name/Deviation Range array.

See attached modification of your file.

Hope you find this useful.

Cheers

[ProFromMars]

Hi!

Interesting solution, thank you! I had to make some changes in my database in order to make it function properly, but it works!

Cheers!

[southward]

Glad I could be of some assistance.

Cheers