ExcelBanter - Using a formula on anumber of cells in a column that the user inpu

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using a formula on anumber of cells in a column that the user inpu (https://www.excelbanter.com/excel-discussion-misc-queries/116721-using-formula-anumber-cells-column-user-inpu.html)

Charissa

Using a formula on anumber of cells in a column that the user inpu

Hi,
I would like to be able to calculate the standard deviation of the first 'n'
cells in a column, where 'n' is a value entered into a cell by the user. Is
this possible to do without a macro?
Thank you,
~Charissa

Toppers

Using a formula on anumber of cells in a column that the user inpu

try:

=STDEV(INDIRECT("B1:B"& C1))

Where column B contains the data and C1 contains n

HTH

"Charissa" wrote:

Hi,
I would like to be able to calculate the standard deviation of the first 'n'
cells in a column, where 'n' is a value entered into a cell by the user. Is
this possible to do without a macro?
Thank you,
~Charissa

All times are GMT +1. The time now is 07:15 AM.