#### DID

##### New member

- Joined
- Jan 14, 2014

- Messages
- 15

- Reaction score
- 0

- Points
- 0

I really hope that today you can help me with the formula I need for Excel here is my setup:

I have several data sets (up to 600.000 rows in total). In column A, I have a number (e.g. 1) represents data set 1 (i.e. row #2 till row #3.000 all marked as "1" i Column A). Data set 2 i represented as "2" still in column A, but ranging from row #3001 till ca #6000. And so it continues up to ca. 600.000, where I have ca. 3500 data sets. In Column B I have the corresponding results from the different data sets.

Now, I would like to make a formula for determining the Standard deviation and Variance for the different data sets corresponding results.

In other words, what I would like to the program to do is: "For all the "1"'s in Column A, I want to calculate the Variance and Std.Dev., and for all the "2" in Column A..... etc"

I really hope that you understand what I mean, and that you are able to help me...

All the best,

DID