Main Profile

At A Glance

Mr Excel & excelisfun Trick 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.
Length: 07:24

Contact

Questions about Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List

Want more info about Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question