kingjeremy Wrote:
Hi,
ı want to fill series based on cell data, a sample is below
a1 b1
james 10
jane 8
... ..
result should be

james 1
james 2
james 3
...
james 10
jane 1
jane 2
...
jane 8

thanks for any help.

Hi kingjeremy

Not 100% sure what you want but here goes

If James is in cell A1 and 1 is in B1, select both cells, move cursor
to bottom right of selected cells, it becomes a black cross, hold down
left mouse button and drag down

or if James is in Cell A1 and 10 is in B1 to fill the gaps back to
James 1, you will need to insert rows above James 10 and then do the
same thing but drag upwards


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397155