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.

Small & Large Rows & Columns This is an extension of this post:  Small & Large & Row & Column I decided to embed within the Sum and Xlookup formulas the SMALL and LARGE function. I used it to find the sum of the 2 largest and smallest invoice amounts. I used the Xlookup to find the 2 smallest and largest invoice numbers this time.

Small & Large Rows & Columns The SMALL and LARGE function can return the smallest or largest value at the kth value. So it is not restricted to finding the ABSOLUTE smallest or biggest number. It can return the 2nd or 3rd smallest or largest, etc. This is useful if I have a large payment request and the treasury wants me to find the 2 largest invoices to send a pdf copy proof before the treasury approves and sends out ACH that Friday of the week. The ROW and COLUMN formula can return the respective row and column of a cell. The ROWS and COLUMNS returns the total number of rows and columns in an array/table.