| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Information from one cell pulls information from another cell
Hi All,
What I am trying to do is set up a command that will look at infomration in one column and then if one of the cells meets a criteria then it takes the corresponding cell data in another column and puts it into a list. IF cell in range H2:H327 is < 0 THEN matching row/cell data is put into another cell or list. Should I do a word document combo output? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Information from one cell pulls information from another cell
In the "other cell" (say J2:J327) put this code =if(H2<0, H2,"")
What this says is: If H2 <0 then put H2 int J2, otherwise put nothing. Glen "ACTLibrarian" wrote in message ... Hi All, What I am trying to do is set up a command that will look at infomration in one column and then if one of the cells meets a criteria then it takes the corresponding cell data in another column and puts it into a list. IF cell in range H2:H327 is < 0 THEN matching row/cell data is put into another cell or list. Should I do a word document combo output? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use other cell information to put formula in current cell | Excel Worksheet Functions | |||
| If blank cell, copy information from cell above | Excel Worksheet Functions | |||
| enter a value, excel pulls information and places in new spreadshe | Excel Worksheet Functions | |||
| When copying a cell to another cell the information is duplicated. | Excel Worksheet Functions | |||
| Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
Linear Mode
