google spreadsheet - Pre-populating a column in a row based on related rows -
    i have following dataset in google spreadsheet   +-------------------------------------------+------------------+                                         |software name  |operating system           |    multiple os?  |                                         +--------------------------------------------------------------+                                         |office         |windows                    |yes               |                                         |office         |mac                        |yes               |                                         |vmware fusion  |mac                        |no                | |vmware fusion  |mac                        |no                                                                                +---------------+---------------------------+------------------+    i been trying find way automatically populate multiple os field yes/no. should occur when there duplicate software entries different operating systems.   i expect...