We have an Excel file book1.xlsx as follows:

In B2:G2, continuous non-null values are 1755, 6666, and 1438 in recent three days. 

Put the maximum value in A2.

In B3:G3, continuous non-null values are 3060, 2780, and 2650 in recent three days.

Put the maximum value in A3.

In B4:G4, continuous non-null values are 345, 12, and 4 in recent three days.

Put the maximum value in A4.

The expected result is as follows:

Directions: 

1. Start esProc (Download esProc installation package and free DSK edition license HERE. You will be prompted to load the license file when you run esProc for the first time).

2. Open Option>add-ins in Excel and click the Go button to load add-ins ExcelRaq.xll. The add-in file is located in [esProc installation directory \bin]directory. Refer to related Excel documentation if you don’t know how to do the loading. 

3. Now enter the following formula in A2 to get the result: =esproc("=?1.group@o(~!=null).select@z1(~.len()>=?2 && ~(1)).to(-?2).max()",$B2:$G2,3). The formula can be reused in other cells to do subsequent computations. Parameter 1 represents all data in the current row; parameter 2 means non-null values in continuous n days.