By Newellmyra - 4/28/2010
I have a column in Excel that contains a formula. It is the same on every row, except for one number. I want to make this value to automatically count up by one every row. I want the rest of the formula to remain identical. Can I get Excel to to this automatically or do I need to manually change the formula every single row? Thanks!
|
By Perrie - 5/5/2011
Place a column next to that column and fill it with a series, incrementing whatever amount per cell then make the formula reference the cells in that column. If you want to make it look tidy, simply hide the column containing the sequential values.
|
|