I've got Excel Bible 2016 and cannot find the answer anywhere in it...

it has plenty about pulling the first or last in a string... but not what I'm looking for...

here is what I'm looking at:

Screen Shot 2016-02-04 at 10.22.48 PM.pngScreen Shot 2016-02-04 at 10.23.22 PM.png

this is my main workbook (I call it DATA_TABLE_1) where I want to... in a separate worksheet... create a horizontal log for each player in order... as favorite and as dog and both combined...

where lets say any time in Column Q, Dominika Cibulkova is listed, I will run a COUNTIFS for that and her being >0 in Column AY (signifying a win for her in that match)... that would be in the new worksheet, next to her name with a "W" in that column next to her name... next match she plays repeat the procedure... and add a W for Win (>0) or an L for Loss (=0) in column AY

and preferably add the date horizontally in Row 1 also... but that being greedy...

I'm mainly concerned about developing the sequence log...

so combining the information would make a row for Dominika Cibulkova that would look like this...


Screen Shot 2016-02-04 at 10.37.49 PM.png