Finding values closest to a certain number then returning th

lars92RS · Feb 28th, 2002, 07:29 AM

I have 3 columns of data. I want Excel to find the value that is closest to a specified value then display that row in another sheet. For example I want to find the value closest to 65 and I have 64.8 and 65.4, i want excel to pick the row with 64.8 and then put that row of data in another table I specify. I'm looking for VBA code for the most part. Thanks to all!!!

-Lars

[ This Message was edited by: lars92RS on 2002-02-28 09:06 ]

lars92RS · Feb 28th, 2002, 10:56 AM

ttt

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 07:29 AM	#1
lars92RS New Member Join Date: Feb 2002 Posts: 4	I have 3 columns of data. I want Excel to find the value that is closest to a specified value then display that row in another sheet. For example I want to find the value closest to 65 and I have 64.8 and 65.4, i want excel to pick the row with 64.8 and then put that row of data in another table I specify. I'm looking for VBA code for the most part. Thanks to all!!! -Lars [ This Message was edited by: lars92RS on 2002-02-28 09:06 ]

Feb 28th, 2002, 10:56 AM	#2
lars92RS New Member Join Date: Feb 2002 Posts: 4	ttt