Sort two tables by approximate values

[andymarkwell1]

Hi all,

Just looking to see if something is possible and if so how.

Table A will have data with values e.g. £100,000, £105,000, £100,500, £230,000, £170,000.

Table B will have data with values e.g. £99,990, £104,300, £100,200, £228,000, £169,700, £403,000.

All bar the last figure on in Table B can be matched, but there is small degree of inaccuracy.

What I want to do is to create a table that sorts the data and and matches by value.

So in the example above, £403,000 wouldn't have a pair. The rest would be paired in numerical order.

Is this possible?

Thanks

Andy

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[andymarkwell1]

Apologies. Now attached.