I have a data set of some 7000+ rows, and i need to be able to
determine the standard deviation of a single row, then determine the
standard deviation of all the rest of the data combined. this then
needs to be replicated for every single row. If i can just have
someone give me an example of how to select everything EXCEPT a single
row that would be perfect! any help would be a life saver! thanks in
Advance!

example.
row 1
row 2
row 3
row 4

so for the first standard deviations it would be the standard
deviation of row 1, then ffiguring out the standard deviation of rows
2 through 4.
the second would be the standard deviation of row 2, then the standard
deviation of rows 1, 3, and 4.
I hope this helps!