Need help with lookup

Dave Gibson · Apr 16th, 2002, 11:30 AM

I think I can do this with a lookup function, but I need help to find the simplest way. I've got two columns of uncorrected data featuring elapsed time and a corresponding value. I need to compare the value to a standard deviation, and if the value is less than the sd, enter the elapsed time and value in two adjacent columns as corrected data. Is there an easy way to do this?

teebruin · Apr 16th, 2002, 11:35 AM

Is the SD just one value that is in a cell somewhere, or is this a value that must be looked up from a list of several values? If it's just 1 single value, then all you need is an IF formula.

Aladin Akyurek · Apr 16th, 2002, 11:37 AM

Quote:

On 2002-04-16 10:30, Dave Gibson wrote:
I think I can do this with a lookup function, but I need help to find the simplest way. I've got two columns of uncorrected data featuring elapsed time and a corresponding value. I need to compare the value to a standard deviation, and if the value is less than the sd, enter the elapsed time and value in two adjacent columns as corrected data. Is there an easy way to do this?

Lets say that A2 houses an elapsed time and B2 the corresponding value.

In C2 enter: =IF(LEN(D2),A2,"")

In D2 enter: =IF(B2

Dave Gibson · Apr 18th, 2002, 06:21 AM

The SD is one value, so I tried using an IF function. The problem is, the current worksheet allows for 25 data points. That's too many for a nested IF statement. But you have the idea. What I want to do is compare the value in row 1 to the SD. If it's less, then enter that value in row 1. If it's more, then compare the value in row 2 to the SD. If it's less, enter the value in row 1. The point is to extract the qualifying data from one column and transfer it to another column without any blank cells.

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

Apr 16th, 2002, 11:30 AM	#1
Dave Gibson New Member Join Date: Feb 2002 Posts: 6	I think I can do this with a lookup function, but I need help to find the simplest way. I've got two columns of uncorrected data featuring elapsed time and a corresponding value. I need to compare the value to a standard deviation, and if the value is less than the sd, enter the elapsed time and value in two adjacent columns as corrected data. Is there an easy way to do this?

Apr 16th, 2002, 11:35 AM	#2
teebruin New Member Join Date: Mar 2002 Posts: 38	Is the SD just one value that is in a cell somewhere, or is this a value that must be looked up from a list of several values? If it's just 1 single value, then all you need is an IF formula.

Apr 18th, 2002, 06:21 AM	#4
Dave Gibson New Member Join Date: Feb 2002 Posts: 6	The SD is one value, so I tried using an IF function. The problem is, the current worksheet allows for 25 data points. That's too many for a nested IF statement. But you have the idea. What I want to do is compare the value in row 1 to the SD. If it's less, then enter that value in row 1. If it's more, then compare the value in row 2 to the SD. If it's less, enter the value in row 1. The point is to extract the qualifying data from one column and transfer it to another column without any blank cells.