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.
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.