Dueling Excel 129

DESCRIPTION

Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula?
See Mr Excel and excelisfun use two methods to create Dynamic Range For Last Ten Numbers in Coulmn:
1. OFFSET function to create dynamic range
2. INDEX function to create dynamic range
3. Formula that will skip over empty cells and get the actual 10 last numbers in the column, excluding empty cells

WORKBOOKS




Be the first to comment

Leave a Reply