I have come up with the following formula and would like to now use it on in every row. I want each row to calculate the values in THAT row. Is there an easy way to copy this formula to all rows?
I have been using copy/paste and then dragging the selected cells to match the rows but I will go insane doing that several hundred times.
Thanks,
John
=IF(COUNT(E2:AE2)>14,AVERAGE(E2:AE2),"DNQ")
Bookmarks