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...