Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SSS148 on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Range lookup

Status
Not open for further replies.

Bert2

Mechanical
Feb 17, 2010
80
Hi,

Bit rusty on the old excel.

Could someone point me in the direction of what I need to do for;

having a series of data values in a vertical column searching for values between two numbers ie: 12 & 15, then displaying the values in a new table .

thanks for the help.
Bert.
 
Replies continue below

Recommended for you

thanks DRWeig,

great help!
 
Here's a slight improvement, in cols F and G. It might be possible to improve further by removing the need for the helper column. A further improvement would be to remove duplicates (if that is what the OP would like), but I suspect that this would be harder.

And I've just run out of time. (How convenient.)
 
 http://files.engineering.com/getfile.aspx?folder=0d431157-91f4-461e-ad94-d137ab3835f3&file=Find_values_in_range_(second_way).xlsx
Thanks

Denial almost spot on , as you said improving only be removing the helper column.

thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor