Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Question on one line of code - parentheses and quotation marks
I don't understand the following line of code.
"=MID(R[0]C[-2],INDEX(FIND({""(403"",""(587""},R[0]C[-2]),MATCH(TRUE,ISNUMBER(FIND({""(403"",""(587""},R[0]C[-2])),0)),14)" 1. Why and when should square brackets be used? 2. Why & where should curved brackets be used? 3. Why are there double sets of quotation marks around the (403 and (587 4. I've never used the R[0]C[-2] nomenclature. Is this example designating a cell location that is on the same row bur two columns left? 5. I can't find reference to MATCH(TRUE,ISNUMBER. What is this doing? Thanks to anyone that takes the time to answer this. Jim Berglund |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding quotation marks to each line of cell contents with carriagereturns | Excel Programming | |||
Quotation Marks | Excel Programming | |||
Quotation Marks | Excel Discussion (Misc queries) | |||
Quotation marks and variables within code | Excel Programming | |||
Quotation Marks | Excel Programming |