Thread: Copy the formula by dragging but down but calculate by going left
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Copy the formula by dragging but down but calculate by going left
Hi Frank,

Am Thu, 13 Oct 2016 10:54:39 -0700 (PDT) schrieb F.G.:

It works, can you explain how the actual formula works.

Row(A1) is the column of the INDEX and will be increased by one when you
copy the formula down.


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote