| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
The "Fill Handle". See:
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Lisa" wrote in message ... that works but how do we set it for the entire column? "Anne Troy" wrote: =if(a2="tmt",h2,"") Hi, Lisa. What did you want if it doesn't = TMT? I made it so the cell remains blank. ************ Anne Troy www.OfficeArticles.com "Lisa" wrote in message ... If column A="TMT" then I want it to go to column h and pick up the value. How do I set this up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Threaded Mode
