Pivot Table Repeater Formula...

[radar2000]

Hi everyone.

I've tried doing a search, but did not find what I was looking for.

I'm using Excel 2003 and just ran a pivot table on a large sum of data. Worked great! So I copied what I needed over to a separate worksheet.

In this separate worksheet, I have 2 columns of data that lookls like this:

Name Points
------- -------
Bill 10
blank 20
blank 20
blank 20
Joe 10
blank 20
Sam 10
blank 20
blank 40

Is there an Excel if formula that will do the following?...

Name Points
------- -------
Bill 10
Bill 20
Bill 20
Bill 20
Joe 10
Joe 20
Sam 10
Sam 20
Sam 40

I'm working with over 10,000 lines here and it would be painfull to have to copy and paste this

Any help would be appreciated.

Thank you.

 

[Juan Pablo González]

Try this:

http://www.mrexcel.com/tip004.shtml

 

[radar2000]

Magic...Pure Magic!!!

Thanks Juan! That did the trick!