extract values, one from calculated formula

[skunkworks]

In the royalty spreadsheet shown here, authors and their books are listed. Some authors may have only one book, while others may have a dozen. "Author Total Royalty" is a calculated field. I would like to be able to extract the author's name and "Author Total Royalty" into another worksheet. How can this be done?

 

[skunkworks]

Alex, that worked perfectly! You saved lots of manual work and the possibility of introducing errors by this brilliant solution. Thank you, thank you, thank you!

 

[Alex Blakenburg]

Thanks for letting me know so quickly. Glad we could help.