View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Difficulty in transposing

Peo, thanks for the help !

Richard: In the top formula cell for copying down, I'd use ROW(A1) out of
"convention". ROW(B1) , ROW(C1), ROW(D1) ... all of these also return the
same result as ROW(A1) and could have been used instead of ROW(A1) as the
incrementer within the INDEX formula.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---