Hi - this the last question I have on a project, and it's a tricky one (to me!)
Description: I keeping a spreadsheet for monthly Reading Group that shows month/author(s)/title(s)/page count/author gender/etc.
<colgroup><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>
</tbody>MonthCt = 10
TitleCt = sum(titlect) = 11
AuthorCt = 9 (male = 4, female = 5)
Problem 1: I want a count of distinct authors across TWO columns. In the sample data above, Steinbeck & Pratchett are repeated and two months have co-authors. Correct count of unique authors = 9.
Problem 2: Gender and other demographic data is kept for the first author only, but I don't want duplicates. I'm managing this by leaving demo data blank for the second or subsequent instance of the author. It's working for me, but is there a better way to do this?
Thanks for your help - you guys are great!
Description: I keeping a spreadsheet for monthly Reading Group that shows month/author(s)/title(s)/page count/author gender/etc.
Month | Author1 | Author2 | Title1 | Title2 | TitleCt | BookPageCt | AuthorGender |
1 | Steinbeck, John | The Grapes of Wrath | 1 | 423 | m | ||
2 | Atwood, Margaret | Cat's Eye | 1 | 423 | f | ||
3 | Gaiman, Neil | Pratchett, Terry | Good Omens | 1 | 432 | m | |
4 | Selvon, Sam | The Lonely Londoners | 1 | 432 | m | ||
5 | Lively, Penelope | Moon Tiger | 1 | 432 | f | ||
6 | Stephanie Meyer | Bram Stoker | Twilight | Dracula | 2 | 867 | f |
7 | Austen, Jane | Persuasion | 1 | 423 | f | ||
8 | Pratchett, Terry | The Colour of Magic | 1 | 423 | m | ||
9 | Steinbeck, John | Tortilla Flat | 1 | 432 | |||
10 | Highsmith, Patricia | The Talented Mr. Ripley | 1 | 432 | f | ||
<colgroup><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>
</tbody>
TitleCt = sum(titlect) = 11
AuthorCt = 9 (male = 4, female = 5)
Problem 1: I want a count of distinct authors across TWO columns. In the sample data above, Steinbeck & Pratchett are repeated and two months have co-authors. Correct count of unique authors = 9.
Problem 2: Gender and other demographic data is kept for the first author only, but I don't want duplicates. I'm managing this by leaving demo data blank for the second or subsequent instance of the author. It's working for me, but is there a better way to do this?
Thanks for your help - you guys are great!