I have a column of numbers in A1:A1000 and a number that is in cell G1. In cell G2 I want to make a average of the numbers in Column A1:A1000 that are within 5% +or- of the value in G2. Can anyone help me on this?
Thanks
Adam
Thanks
Adam