What is an array formula?
How do we interpret formulas such as (D2:D7)*(E2:E7) and SUM(D2:D7*E2:E7)?
I have a list of names in a single column. These names change often. Is there any easy way to transpose the listed names to a single row so that changes in the original column of names are reflected in the new row of names?
I have a list of monthly stock returns. Is there a way to determine the number of returns between -30 percent and -20 percent, -10 percent and 0 percent, and so on that will automatically update if I change the original data?
Can I write a single formula that will sum up the second digit of a list of integers?
Is there a way to look at two lists of names and determine which names occur on ...