| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address in IF formula.. doens work..
Hi.
I´ve made the following formula but it doesn´t assume the values in the address formula..... why? =IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"") A1=Sheet2! Thanks a lot SpeeD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to server address does not work after save | Links and Linking in Excel | |||
| Why won't ADDRESS work nested inside SUMIF? | Excel Discussion (Misc queries) | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| email address links doesn't work on some cells?????? | Excel Discussion (Misc queries) | |||
| How do I create a name/address/phone 3-column list from Excel work | Excel Discussion (Misc queries) | |||
Threaded Mode
