Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Skip cell if X nonexistent, populate next cell
OK here's my dilemma; hope I explain myself clearly as I'm new at
this. I have a worksheet that pulls the names and IDs of casino players enrolled in different groups from a database. Every person in the group is assigned a player ID. Not every person plays, however. I'm compiling a report that shows actual and theoretical win for each player. Table X stores player names and IDs, table Y stores player statistics. I calculate actual and theoretical win from table Y, set up a pivot table, and link 2 other columns to the pivot table to display actual and theoretical win. Problem is, only players who actually play have any records in table Y. The bosses want to see ALL persons enrolled in group X, whether they played or not. With my limited knowledge of Excel, I have 2 options: A. I modify the report to show ONLY those persons in the group who actually played. B. I show all persons in the group, but the player name/IDs and actual/ theoretical win figures will no longer match up. e.g group 234 includes the following, modified to show only persons who played: Plyr ID Last Name First Name Theo Win Actual Win 53082 Duck Donald $0.60 $10.00 53084 Man Super $26.30 $70.00 53087 Baby Big $1.20 $3.75 53088 Dick Moby $28.10 $83.75 Everyone's play is correctly attributed to him/her, but when I modify the report to include persons who did NOT play, Mr. Jolly Green Giant now appears on the list, and has Big Baby's figures incorrectly attributed to him, Big Baby in turn gets Moby Dick's data, and so on and so on. Plyr ID Last Name First Name Theo Win Actual Win 53082 Duck Donald $0.60 $10.00 53084 Man Super $26.30 $70.00 53085 Giant Jolly Green $1.20 $3.75 53087 Baby Big $28.10 $83.75 53088 Dick Moby How can I extract actual and theoretical win from the pivot table (which contains ONLY those players who played, along with their stats), match it up with the corresponding player IDs and names on the report (which contains ALL player IDs/names whether they played or not) and instruct Excel to skip or better yet populate with '$0.00' those cells that belong to players who did NOT play? As in Mr. Jolly Green Giant would now be included on the report, but would have '$0.00' in his 'Theo Win' and 'Actual Win' columns: Plyr ID Last Name First Name Theo Win Actual Win 53082 Duck Donald $0.60 $10.00 53084 Man Super $26.30 $70.00 53085 Giant Jolly Green $0.00 $0.00 53087 Baby Big $1.20 $3.75 53088 Dick Moby $28.10 $83.75 Really hope I'm being clear enough about what I need, as I said, I'm new to this, but trying to be precise and provide all necesssary information. Any guidance is deeply appreciated. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate current active cell - Help Please!! | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |