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.


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