Basically you replace Sheet3!C2 with the construct I provided
OFFSET(Sheet3!$C$2,(ROW()-ROW($B$2))*3,0)
Thus:
=LEFT(OFFSET(Sheet3!$C$2,(ROW()-ROW($B
$2))*3,0),FIND("--",OFFSET(Sheet3!$C$2,(ROW()-ROW($B$2))*3,0))-1)
=RIGHT(OFFSET(Sheet3!$C$2,(ROW()-ROW($B$2))*3,0) ,(LEN(OFFSET(Sheet3!$C
$2,(ROW()-ROW($B$2))*3,0) )-FIND("--",OFFSET(Sheet3!$C$2,(ROW()-ROW($B
$2))*3,0) ))-2)
Regards,
Kostis
Thanks Kostis,
That works great!
I have used another formula to extract 2 piece of data from those
specific
cells which occur before and after this text "--"
Those formulas are:
For data before -- =LEFT(Sheet3!C2,FIND("--",Sheet3!C2)-1)
For data after --
=RIGHT(Sheet3!C2,(LEN(Sheet3!C2)-FIND("--",Sheet3!C2))-2)
Can you help me integrate your formula into these formulas?
Thanks again,
Brian
I want to get data from another worksheet, but the data I want occurs
in
every 3rd row.
So I want data from C2, C5, C8, etc.
How can I do this in a formula so that when I drop the formula down,
the
sequence will replace correctly?
In any cell (say B2):
=OFFSET('[otherbook.xls]sheetname'!$C$2,(ROW()-ROW($B$2))*3,0)
HTH
Kostis Vezerides
