View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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..