B byersnt New Member Feb 26, 2012 #1 Hi, I'm wondering how to make a list in a column of 1-any value. So if the value is 20, the column values would read 1, 2, 3, 4 and so on all the way to 20 (in the 20th row)
Hi, I'm wondering how to make a list in a column of 1-any value. So if the value is 20, the column values would read 1, 2, 3, 4 and so on all the way to 20 (in the 20th row)
Faseeh Excel Ninja Feb 26, 2012 #2 Hi byersnt, Should this formula work or you (Enter in First Row of any column & drag down) =IF(ROW()<=20,ROW(Sheet1!$A1),"") This will show what you want to do till row 20, after it will show a dot (.). Regards, Faseeh
Hi byersnt, Should this formula work or you (Enter in First Row of any column & drag down) =IF(ROW()<=20,ROW(Sheet1!$A1),"") This will show what you want to do till row 20, after it will show a dot (.). Regards, Faseeh
SirJB7 Excel Rōnin Feb 28, 2012 #3 Hi, byersnt! Let's say your talking about column A. In A1 type, and then copy down to A2:A20 (or up to needed row) this: =ROW() Regards!
Hi, byersnt! Let's say your talking about column A. In A1 type, and then copy down to A2:A20 (or up to needed row) this: =ROW() Regards!
