|Subject:||yes or no results spreadsheet|
|Date:||Tue, 23 May 2006|
I have a very simple excel table, 3 columns, many rows.
ColA = response 1 (y or n)
ColB = response 2 (y or n)
ColC = Include (y or n)
What I want ColC to produce is as follows:
If ColA and ColB are both y, then ColC is y
If ColA and ColB are both n, then ColC is n
If ColA and ColB disagree (one y, one n), then ColC is n
I need a formula so I donâ€™t have to go through each row (there are 1000 or
so) and enter each response in ColC by hand.
Thanks for your help.