4 Replies Latest reply on Dec 13, 2016 1:57 PM by Christina Davis

    average based on values in previous columns

    sabina.martin
      Column AColumn BColumn C
      112212345650.00
      112245698750.00
      113378956454.00
      1144789523120.00
      115578562489.00

      Hi, I'm having trouble coming up with the formula that will say if there is a duplicate number in column A (i.e. 1122), take the average from Column C,  in this case 123456 is 50.00 and 456987 is 50.00, the average then for 1122 is 50.00. thank you