Excel Magic Trick 1288

DESCRIPTION

Why Doesn’t =ROW(1:LEN(A1)) Work?
Learn the formula =ROW(1:LEN(A1)) does not work. See that the INDIRECT Function comes to the rescue to create a formula that does work: =ROW(INDIRECT(“1:”&LEN(A1))) Work. Alos learn about the robust method for creating an array of sequential numbers using =ROW(A1:A5)-ROW(A1)+1.

WORKBOOKS

Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 767 times – 4 MB




Be the first to comment

Leave a Reply