Expanding cells again
Hi TripleX -
=IF(OFFSET('01'!$B$1,(ROW()-0-1)*16,0,1,1)=1444093,"Standard","Turbo")
Copy this to Row 1 and 'expand' downward. Note that if you want to start
your list of these formulas in any other row than row 1, say for example row
10, then:
1. Copy the formula to cell A10 (or any other column in row 10).
2. Change the characters "-0" to "-9" to correct for the 'distance' from row
1.
3. Copy (expand) the formula downward.
---
Jay
"TripleX" wrote:
I need to expand these cells, (it's always +16), how can i do it?
=IF('01'!B1=1444093;"Standard";"Turbo")
=IF('01'!B17=1444093;"Standard";"Turbo")
=IF('01'!B33=1444093;"Standard";"Turbo")
, when i expand it, it should continue like this:
=IF('01'!B49=1444093;"Standard";"Turbo")
=IF('01'!B65=1444093;"Standard";"Turbo")
and so on..
|