# 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.
{"ft_lang_label":"__label__en","ft_lang_prob":0.75277185,"math_prob":0.9898907,"size":494,"snap":"2019-13-2019-22","text_gpt3_token_len":148,"char_repetition_ratio":0.10204082,"word_repetition_ratio":0.0,"special_character_ratio":0.30161944,"punctuation_ratio":0.115384616,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9871076,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-05-25T16:04:42Z\",\"WARC-Record-ID\":\"<urn:uuid:828e9893-6cef-40b5-849b-37682a2801fa>\",\"Content-Length\":\"73419\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:1b4e8742-6846-4046-afdd-3c53c6923678>\",\"WARC-Concurrent-To\":\"<urn:uuid:c7ba4f4f-ebf5-404f-aff7-a681773da2a0>\",\"WARC-IP-Address\":\"185.11.240.163\",\"WARC-Target-URI\":\"http://masterexcel.net/excel-magic-trick-1288/\",\"WARC-Payload-Digest\":\"sha1:BQE4IDOZBBL2NUIYQIDFLNTWKNYWGBIE\",\"WARC-Block-Digest\":\"sha1:MTBH5L4J2R32JOVASI2I32NQG6WIJI5X\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-22/CC-MAIN-2019-22_segments_1558232258120.87_warc_CC-MAIN-20190525144906-20190525170906-00242.warc.gz\"}"}