Compare values from a column between them

Welcome to the forum!

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Please check your attachment - it is reporting as not a valid file type.

Unable to here, sorry, so I am not able to help.

This proposed solution employs a helper table to find only the rows of data that have a temperature within the prescribed variance (+/- 3%). The table is populated using the following array entered formula*:

Formula:

Please Login or Register  to view this content.

The second table could be used as the final result table if the target temperature and radiation were put in another location. The second table is populated by an array entered formula* that is similar to the first, however it draws data only from the first table.
*Array entered formulas are activated by simultaneously pressing the Ctrl, Shift and Enter keys while the cell containing the formula is in edit mode.
Let us know if you have any questions.

What you are describing sounds like a loop:
1) Find the ith temp and radiation level
2) Find all temps that are within a variance of 3% of the initial temp
3) From that list find all radiation levels that are within a variance of 3% of the initial radiation level
4) If there are additional records meeting the parameters display them
5) If there are no additional records meeting the parameters iterate i and go back to step one.
I believe that doing that would require VBA.
I would suggest starting a new thread on the VBA forum at this site (Excel Forum). In your post include a link to this thread so that volunteers can get a sense of what you want to accomplish.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark this thread as 'Solved' (since it appears to have gone as far as it can) using the thread tools link above your first post. I hope that you have a blessed day.