Ask Your Question
0

fill a series in a non adjacent cells [closed]

asked 2012-09-08 08:24:25 +0200

anonymous user

Anonymous

updated 2012-09-08 08:25:22 +0200

hello every one, how can i fill a one step value series in a non adjacent cells?

for example i've cells

A20 A23 A24 A27 A30

i just want them incremented by 1 A20 val=2, A23 val=3, A24 val=4, A27 val=5, A30 val=6, , ... val=7

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 23:23:35.118099

1 Answer

Sort by » oldest newest most voted
1

answered 2012-09-08 10:46:16 +0200

JohnSUN gravatar image

Insert a formula in cell A20

=MAX($A$1:A19)+1

Copy this cell

Insert in the all the necessary cells below

edit flag offensive delete link more

Comments

Simple but clever solution - +1 from me!

tohuwawohu gravatar imagetohuwawohu ( 2012-09-09 12:37:25 +0200 )edit

Question Tools

Stats

Asked: 2012-09-08 08:24:25 +0200

Seen: 202 times

Last updated: Sep 08 '12