Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
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 |