Hello agian, I'm full of questions it seems
I am wondering is there is a way to tell Excel to produce an average of certain column's cell values for rows which have a combination of values in column A and B.
Please see excel file attached.
I need an average of column's N cells for rows 1 to 9 because those cells all have 'Trial001' as a value in column A and P01 as a value in column B. I need averages of all unique combinations of values in column A and B.
That is, I need an average of the cells in column N for rows which have Trial002 and P01, Trial003 and P01 and so on for all 75 trials.
Then I need an average of all cells in column N for rows which have Trial001 and P02Pilot, Trial002 and P02Pilot and so on for all the trials.
Then same for P02Pilot and so on for every value in column B (in this sheet goes until P18).
I understand that I can do this manually by applying AVERAGE function, but I have many sheets like that and it would be very time consuming. Is there a way to tell excel to do this automatically for all rows with a unique combnation of values in columns A and B? That would save me weeks of work..weeks I really need!
Thank you all kind folk!
Bookmarks