My routine work in excel is such that I should constantly make operation on two or more data set on the same column. (For example, According to sample-attached file, range B2:B7 is Sales Value and range B8:B13 is Sales Volume and in order to get price, I want to have B2:B7 divided byB8:B13). To make such operations easier, I have defined name for each data set (for example I have defined name “Sales. Value for B2:B7 and Sales. Volume for B8:B13) and Now I am seeking an option in Excel which give me the possibility to divide two date sets (Sales. Value and Sales. Volume) by using difined name (something like element wise operation in Matlab (Sales. Value.*/Sales. Volume)). Is there a way to do that? (Although may in the example attached file, doing such endeavor dose not worth the effort, In my real routine work, which is more complex consisting of many such data sets which are not necessarily adjacent to each other, doing such operation make many difference and make the formulas much readable and "error identification" much easier)

Attached Files

example.xlsx (9.1 KB, 12 views)