Dueling Excel 70

Lookup & Return Last 5 Numbers in a List


See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Items in a List using INDEX and COUNT functions. See a retractable range in a formula where the last cell reference in a range is absolute but the first cell reference in the range is relative — thus creating a retractable (shrinking) range.


Be the first to comment

Leave a Reply