Thread: formulate all in one cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default formulate all in one cell
Hi,

Try using =SUM(10-ROW(A1:A20)) entered as an array formula using
Contol-Shift-Enter, instead of just Enter.

Dave

url:http://www.ureader.com/msg/104240746.aspx
Reply With QuoteReply With Quote