I have two columns of numbers with the same amount of numbers. Lets call them Column A and Column B.
I need to find the standard deviation of Column B divided by Column A.
How do I write one function that completes this?
I know that I can divide out Column B and Column A into a separate Column and then find the STD of that. But I need to be able to do that in one function.
Try an array formula** something like this:
=STDEV(B2:B5/A2:A5)
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Adjust the ranges to suit.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Perfect, thanks.
Solved.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks