View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Expanding cells again

Assuming you do not need thousands of these formulas then this formula should
work for you...

=IF(INDIRECT("'01'!B" & (ROW()-1)*16+1)=1444093,"Standard","Turbo")

Note that the formula is volatile so that it recalcs every time. That means
that it has lots of overhead assocaited with it so you do not want thousands
of these formulas in your spread sheet. If the preforamce starts to drop off
significantly then you might need to rethink this solution...
--
HTH...

Jim Thomlinson


"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..