View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Query content of merged cells

Hello Lucio,

If you want your type of formula I suggest to take
=OFFSET($A$1,0,INT((COLUMN(B$1)-2)/4)*4+1)

But if you want to have a non-volatile function (that is: a function
which does not recalculate each and every time you press F9):
=INDEX($1:$1,0,FLOOR((COLUMN(B$1)-2),4)+2)

OFFSET is volatile, INDEX is not. BTW: FLOOR does exactly what you
introduce with INT(x/4)^4.

Regards,
Bernd