6.4 Search for position of a certain value, take the value by position


We have a statistical table for daily sales of January 2022:


Now we want to find out the day with the largest sales. Enter the following in cell C2:


The returned result is 12.
Next, find out the sales of 5 days before and after the day with the largest sales:



esProc Desktop and Excel Processing
6.3 Filter by position
6.5 Search for row number that satisfies the condition