title: VPA program for compare values in array and give a result (MS Excel)
body: <p>I have some variables in an array. Those may be "Yes", "No", "NA" or "-".
  For example i have an array arr(1 t0 5) . The values would be 'Yes, Yes, No, No &amp; Yes'. The length of array may vary. Like these the combination may vary given that above four values ("Yes", "No", "NA" or "-") 
  My requirement is that i want to compare the values in array and give a result in a cell of excel work sheet. For example, if all values in array are either 'Yes' or 'NA' then result should be "Yes". If any one value is 'No' or '-' then result should be "No". </p>