Thread: how can i use same range of data for different formulas in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ikan Ikan is offline
external usenet poster
  
Posts: 2
Default how can i use same range of data for different formulas in excel?

First define a Name for the range of Cells by pressing CTRL + F3.
Then select the range to which that name applies.
Eg :
=Sheet1!$A$1:$A$10
and add a name for it to be identified by eg. MyRange

thats it and then use it any number of times by simply replacing the name in
place of the range $A$1:$A$10

eg : =Sum(MyRange)


Reply With QuoteReply With Quote