Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 21st 05, 12:13 AM
Robbie
 
Posts: n/a
Default automatically adjust numbers in a column when data is deleted

I have numbers 1 through 17 in cells A264 to A281. I want to be able to
delete information in cell A266 and have the numbers adjust so that instead
of having to retype all of my numbers in again, Excel will automatically
adjust the numbers. Any suggestions?

  #2   Report Post  
Old May 21st 05, 12:49 AM
Mexage
 
Posts: n/a
Default

On A264:

=1

On A265:

=OFFSET(A265,-1,0)+1

Fill Drag A265 to A281

Enjoy.

Hope this helps; if it does, rate my post.

"Robbie" wrote:

I have numbers 1 through 17 in cells A264 to A281. I want to be able to
delete information in cell A266 and have the numbers adjust so that instead
of having to retype all of my numbers in again, Excel will automatically
adjust the numbers. Any suggestions?

  #3   Report Post  
Old May 21st 05, 01:57 AM
Ashish Mathur
 
Posts: n/a
Default

Hi,

Enter the following formula in cell A265 and then copy it down

COUNT($a$264:a264)+1

Now if you delete any row in between, it will continue numbering from the
previous number ant not from one.

Regards,

Ashish Mathur

"Robbie" wrote:

I have numbers 1 through 17 in cells A264 to A281. I want to be able to
delete information in cell A266 and have the numbers adjust so that instead
of having to retype all of my numbers in again, Excel will automatically
adjust the numbers. Any suggestions?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining workbooks with some variable field names Bob Dobalina Excel Discussion (Misc queries) 8 May 17th 05 09:48 PM
Data in column predetermined by what has been entered in previous zan123 Excel Discussion (Misc queries) 6 February 23rd 05 08:03 PM
Comparing Cells and Displaying Data Keith Brown Excel Worksheet Functions 1 February 9th 05 05:42 PM
Multiple Data Validation Criterias MCorrea Excel Worksheet Functions 4 January 20th 05 07:17 PM
filling a forumla down a column from data across a row Doug Excel Worksheet Functions 2 December 9th 04 08:55 PM


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017