Thread: [Solved] Excel AutoFil
View Single Post
 
Old 01-28-2011, 01:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi nai,

Assuming you numbers start in row 1 and continue down in consecutive cells, all you need is =ROW() in the adjacent column. If the numbers start in a row other than 1, use a forumla like =ROW()-X, where X is the number of rows preceding thr starting row.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote