Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet version of VBA JOIN
Can anybody help me create a 'join' between to non-contiguous ranges
to feed into 'Slope'? I saw another question about this on this forum BUT my problem is that the ranges are variable, using offset, rather than fixed. Want I want to do is: Slope(join(offset(a10,0,0,1,a1),offset(b10,0,0,1,b 1)),'known_x's etc) Any help appreciated, Lawrence |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
Worksheet created in French version doesn't work in English versio | Excel Discussion (Misc queries) | |||
Need to retrieve a previous version of an excel worksheet | Excel Discussion (Misc queries) | |||
How do I shut off a second version (xls:2) of a worksheet? | Setting up and Configuration of Excel | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) |