| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
auto numbering text
I have a cell (D6) that has text AV1 in it. Is it possible to have cell A20
check to see if B20 has a number greater than 0 in it, if it does return AV1-1. If there isn't return a blank or "-". At the moment A20 has the following formula in it: =IF('A-V Input'!B200,"AV1-1","") I need to copy this 20 times and the change "AV1-1" manually using the above formula. There are other parts but I want to try and solve this first Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Adjusting Text Box | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| How do I add (auto text) to a paragraph? | Excel Worksheet Functions | |||
| Auto page numbering for several worksheets | Excel Worksheet Functions | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Threaded Mode
