# 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

#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 3Val 1 - Val 2 - Desired result

Report •
Related Solutions