Thanks for your help in advance.
As a quick test of mental agility on a cold afternoon, I have a quick question.
Two tables with numbers like so
Table A Table B
NameID Number Number
AA 1.5 2.3
AB 1.6 4.9
AC 5 11
AD 9.3 24
AE 12 1
What I would like to do is connect numbers from Table B to the closest numerical value in Table A and placing the NameID in a new column next to the Table B number.
Many Thanks for your help I am sure this can be done.
Oliver
As a quick test of mental agility on a cold afternoon, I have a quick question.
Two tables with numbers like so
Table A Table B
NameID Number Number
AA 1.5 2.3
AB 1.6 4.9
AC 5 11
AD 9.3 24
AE 12 1
What I would like to do is connect numbers from Table B to the closest numerical value in Table A and placing the NameID in a new column next to the Table B number.
Many Thanks for your help I am sure this can be done.
Oliver
