average of data by date to probability formula steps help

Hi. I have a large set of prediction market data assorted by date (dates in column A). The data runs from columns B through to Y with some blank cells. I wish to create an average of this data by date. in The z column (one total average for each day). In the column AA I wish to have the calculation of 1/average to give me an average daily probability. Can someone help with the formula required to perform these functions please. I have attached a screen grab to show what part of my spreadsheet looks like. I have attached one of my workbooks in case any kind soul wants to have a bash working this out.excel screen grab.PNG

I can't tell what you're trying to do, but a good start would be to unmerge all the cells in col A, and replicate the dates.

EDIT: Unmerge ALL of the cells in the workbook and replicate data as necessary.

May be this.....

In a new sheet get all unique dates. One way to get that is,

A2, then copy down until get blank.

=IFERROR(SMALL(Sheet1!A:A,ROWS(A$2:A2)),"")

B2, with CTRL+SHIFT+ENTER, then copy down.

Please Login or Register  to view this content.

See attached.