Pivot Table Repeater Formula...

radar2000

Board Regular
Joined
Apr 15, 2002
Messages
85
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 :rolleyes:

Any help would be appreciated.

Thank you.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,147,681
Messages
5,742,587
Members
423,739
Latest member
plkdti

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top