Excel Formula.JPGExcel Formula.JPG
Hi,
I want to create a formula that will give me the average of the column AM but with the range of the value from 1 - 10 from the column AN. In simple words, I want the the average of the last 10 cells from column AM when the number 10 is entered in column AN.
Any suggestions?
Thanks
Bookmarks