Calculate conditional standard deviations in a running list of values

I am trying to calculate a set of ongoing standard deviations of each batsman's performances (runs) from one list that contains multiple batsmen.

Attached is an example of what I am trying to achieve here.

I am aware of the DSTDEVP function but the difficulty with using this function for this case is that the field parameter requires column headers to identify the column that the criteria will be checked against. In a running list of performances, I cannot have a header of column titles above every performance (my spreadsheet has thousands of rows). Also, I want to use this list to lookup standard deviation values for each batsman at different points in time (my actual spreadsheet contains dates as well) so that's another reason why I can't intersperse the records with headers.

I'm wondering is there a way around this where I can still use the DSTDEVP function?

OK thanks. Attached is an enhanced version of this example that includes some manually worked calculations that hopefully better explains what I am trying to achieve here.

Thanks. That works. I forgot about the way you are supposed to enter array formulas.

I tweaked the formula a bit so it calculates the standard deviation of batsmen before the date of the record where the SD is being entered (this is because I am trying to predict the runs scored in the current row). For example in row 23:

=STDEV.P(IF(A$3:A22=A23,C$3:C22))