Increment in excel for non sequence

March 11, 2011 at 04:33:04
Specs: Windows 7
$87,931.00 $87,931.00
$87,931.00 $87,931.00
$87,931.00 $87,931.00
$87,932.00 $87,932.00
$87,932.00 $87,932.00
$87,932.00 $87,932.00
$87,933.00 $87,933.00
$87,933.00 $87,933.00
$87,933.00 $87,933.00
$87,939.00 $87,939.00
$87,939.00 $87,939.00
$87,939.00 $87,939.00
$87,940.00 $87,940.00
$87,940.00 $87,940.00
$87,940.00 $87,940.00
$87,941.00 $87,941.00
$87,941.00 $87,941.00

how do i increment the first column with sequential numerical numbers, excatly the way it is to achieve a complete no number miss in column one. i,e column two has a number miss between87333 to 87339, i want to retain that in column two but have a continuation in column one numerically i.e. 87933,87933,87933 then should continue to 87934 not 89939 like column two. which formula can handle that.
please help


See More: Increment in excel for non sequence

Report •

#1
April 4, 2011 at 08:58:08
This question is poorly worded and 87333 is not to be found in either column.

Try this; re-write your question and columns with a simplified list of 5 rows, and your column data. Then show the desired results in column N and explain how you achived that value.

So:
Col 1 - Col 2 - Col 3
Val 1 - Val 2 - Desired result


Report •
Related Solutions


Ask Question