Enter an IF function in cell L$2$ that shows just the positive values $($sale transactions$)$ in the Amount column. The logical test of the function should evaluate if cell F$2$ is greater than zero. If the logical test is true, define the $[$value$\_$if$\_$true$]$ argument with cell F$2.$ If the logical test is false, the output of the IF function should be $0.$

Copy cell L$2$ and paste it into all of the rows in the dataset by double clicking the Fill Handle.

Sort the entire dataset in ascending order based on the following column sequence: District, Store, and Date. Highlight the entire dataset and then click the Sort button in the Data tab of the Ribbon. This is a critical step that will be required to eliminate the repeating values in the Store Report column.

In cell M$1,$ type the column heading $$Store Week$.$

Enter a CONCATENATE function into cell M$2$ that combines the Store and Week columns. Define the $$text$1$ argument with cell B$2,$ and the $[$text$2]$ argument with cell J$2.$

Copy cell M$2$ and paste it into all of the rows in the dataset by double clicking the Fill Handle.

In cell N$1,$ type the column heading $$Weekly Store Sales$.$

Enter an IF function in cell N$2$ that displays the first instance of the values in the Store Report column. The logical test of the IF function should evaluate if cell M$2$ is equal to M$1.$ If the logical test is true, the output of the function should be $0.$ If the logical test is false, the output of the function should be the value in cell H$2.$

Copy cell N$2$ and paste it into all of the rows in the dataset by double clicking the Fill Handle.

In cell O$1,$ type the column heading $$SKU Check$.$

Enter a VLOOKUP function into cell O$2$ that looks for the SKU $($Stock Keeping Unit$)$ number in cell G$2$ in the SKU List worksheet. Define the $$lookup$\_$value$$ argument with cell G$2.$ Define the $$table$\_$array$$ argument with the range A$2$:A$101$ in the SKU List worksheet. Place an absolute reference on this cell range before defining the next argument. Define the $$col$\_$index$\_$num$$ argument with the number $1$ and the $[$range$\_$lookup$]$ argument with the word $$FALSE$$ to look for an exact match to the lookup value.