Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there One & All, it's me again...
This time around I'm having a problem converting one of John Walkenshaw's Array Formulae to R1C1 addressing as the Help file tells me I'm supposed to. It's not that difficult, but I can't figure out how to put the references in. Here's what I just tried. I didn't expect it to work, but the combinations of quotes (",',`) and ampersands I've already used didn't work either. I'm sure someone out there knows how it's done. All assistance will be gratefully accepted. Selection.FormulaArray = "=index(data,small(if(match(data,data,0) =row(indirect(R2C8:R[rows(data)]C8)),match(data,data,0),''),row(indirect (R2C8:R[rows(data)]C8))))" Thanks in advance, Ken McLennan Qld, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
FormulaArray | Excel Worksheet Functions | |||
Converting code to R1C1 format | Excel Programming |