Main Profile

At A Glance

Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function

See how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm
Length: 05:30

Contact

Questions about Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function

Want more info about Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question