Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difficulty adding RAND generated numbers | Excel Discussion (Misc queries) | |||
I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) | |||
How do I add the sum of a series numbers generated by Rnd gen? | Excel Worksheet Functions |