Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Corrosponding excel generated numbers with 1st row numbers

Does anyone know if you can move the row numbers down that are generated by
excel. Would like my spreadsheet to have corrosponding numbers.

eg.
Row#
1 Job No
2 1
3 2
4 3

Thanks
Anne
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default Corrosponding excel generated numbers with 1st row numbers

try this formula starting at row 2:
=Row()-1
then just fill it down as far as you need to go. The Row() will always
return current row number, so the -1 will reduce that value by 1. Change -1
to whatever you really need if necessary.

"Anne_Nev" wrote:

Does anyone know if you can move the row numbers down that are generated by
excel. Would like my spreadsheet to have corrosponding numbers.

eg.
Row#
1 Job No
2 1
3 2
4 3

Thanks
Anne

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
Difficulty adding RAND generated numbers 47u2caryj Excel Discussion (Misc queries) 2 November 20th 06 11:13 PM
I want random numbers generated without repeating numbers Johncobb Excel Worksheet Functions 2 September 7th 06 04:52 PM
to find missing serial numbers in randomly generated numbers B.H. Hadi Excel Worksheet Functions 2 December 1st 05 10:56 PM
Trouble Sorting Averages of Randomly Generated Numbers GStrawley Excel Discussion (Misc queries) 3 September 5th 05 10:39 PM
How do I add the sum of a series numbers generated by Rnd gen? RandomProblems Excel Worksheet Functions 4 May 2nd 05 04:58 PM


All times are GMT +1. The time now is 06:19 AM.

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

About Us

"It's about Microsoft Excel"