Excel

SMALL & LARGE I used an if statement to produce the invoice amount if the vendor code matches the header of the table. This will create a spill of results because this can occur as little as 0 times or as many times. Now, if I use the LARGE() function on the outside of the if statement, I can restrict it and produce the Nth largest invoice amount. This can be done likewise if I use the SMALL() function. See below.

As a Finance & Accounting Specialist, we pull different reports such as an AP import file. Then we paste them into a raw data tab into a template file so that it is in a suitable format to import into our accounting software. So I decided to create my own import template about Fruits and Vegetables. The if statement is used to change if a cell in the raw tab is blank. I use the xlookup to return the Category and AP code. I include an iferror so that it leaves a blank cell if the food is not recognized from the Legend tab. I also changed the date format on the output tab.

Formulatext I can reference a cell and the FORMULATEXT function will return the formula as a string.