Making multiple comparisions using a +/- variable.

bobnat

New Member
Joined
Jan 13, 2004
Messages
12
Hi all,

This is something I've been working on and I'm quite stumped. I'm sure it's a simple solution, but I've been going through my books and can't find the answer, probably because my understanding at this point is still limited.

As you can see, I've posted what I'm working with. I want to be able to do the following.

Take the .618 of Reaction 1 (1.2670) and compare it to the .382 of Reactions 2-5. Then compare R2 618 to R3-5 .382 and R3 to R4&5 and finally R4 to R5. In the comparision I want to set a +/- using a variable from .0001 to .001. Then if there is a match, let's say I'm using an .0008 variable, then R1 .618 will match up with R2 .382. This would then be displayed in a separate cell.

I know it's asking a lot. I've actually gotten quite a bit of it done, but to be honest, it's quite convoluted and I'm sure there has to be a much simpler way of doing this. Any suggestions will be greatly appreciated.

Bob

========> 1.2681 .382
========> 1.2670 .618
Reaction 1m

========> 1.2662 .382
========> 1.2638 .618
Reaction 2M

========> 1.2662 .382
========> 1.2638 .618
Reaction 3T

========> 1.2624 .382
========> 1.2576 .618
Reaction 4m

========> 1.2605 .382
========> 1.2546 .618
Reaction 5*
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
it would help if you could download colo's html maker (see the lik below this post) & use it to post up a snapshot of you sheet that inlcudes some representative data & an indication of the results you expect...
 

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,467
Members
414,452
Latest member
Dannysamworth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top