FlyerTalk Forums - View Single Post - Excel Question
Thread: Excel Question
View Single Post
Old Jan 11, 2008 | 6:50 am
  #11  
nmenaker
2M
50 Countries Visited
5M
25 Years on Site
 
Join Date: Feb 2000
Location: Menlo Park, CA, USA
Programs: UA 1MM 0P, AA, DL, *wood, Lifetime FPC Plat., IHG, HHD
Posts: 7,174
exactly

Originally Posted by RFTraveler
Simply enter 1 in A4, 2 in A5, 3 in A6...then select those 3 cells (click in A4, click while holding shift in A6). Then, look at the lower right corner of A6 - there's a little square there. Click and hold on the square, then drag down as far as you like.


RFT
exactly, no formula needed. Works with many data sets, dates, even primes!
nmenaker is offline