OK, say for example you have 2 colums of data
a b
re32 1
erf45 3
gre45 2
ghe2 4

You get the point. In excel I basically want to say if its in column b and great than 3 then I want its equivalent in column a (since 4 is greater than the 3, I want the value ghe2) . Is there a function that will give me an entire list as columns a and b are about 120 lines each. Anybody???

4/3/2006 10:45:46 PM

use the IF function.

using your example, say your re32, erf45, and whatnot are in column A, starting at A1 and going to A4. the other column is B1 through B4.

IF(B1>3,A1,3)
(that's assuming that if B1<3, you want 3)

drag the function down and it should adjust to reflect the row that you're on.

[Edited on April 3, 2006 at 10:53 PM. Reason : .]

4/3/2006 10:53:25 PM

Help > Microsoft Excel Help > Search for: "IF"

4/3/2006 10:54:49 PM

I think you could just have a coulmn beside it and say if cell b>3, then this cell ( beside column b) = column a. then just drag it for all of the rows and you will have a column with everything greater than 3 but will have empty blanks in between. then just copy that column and skip blanks as pasting values and you will have all of them i believe.

4/3/2006 10:56:10 PM

Click on the first row in column "c" (or any other column) and type

=IF(B1>3,A1,"NULL")

thiswill test if B1>3. If it is then it returns what's in the column "a" else it ruturns the word "NULL". You could put anything in the last part instead of "NULL". It will then return FLASE.

After you enter the formula in the first row, just click on the right hand corner of the cell and drag down.

[Edited on April 3, 2006 at 10:58 PM. Reason : too sloww]

4/3/2006 10:56:55 PM

ok that helped so thank you! ok what if a value repeats more than 3 times in a column.... is there a function in excel to count that?

4/4/2006 6:56:17 AM

http://www.google.com/search?hl=en&q=excel+count+how+often+a+value+occurs

http://office.microsoft.com/en-us/assistance/HP011277791033.aspx

4/4/2006 11:47:41 AM

countif

4/7/2006 1:36:13 AM