Hey!
I've run into a small problem while creating my sheet. I'll use a screenshot to explain my issue:
screencap.PNG
Basically, I want to search the name column for a specific name (for this example we'll use Bruce). It should search the column to see if "Bruce" is present in it, and perform a formula on the five adjacent cells in its row (in this case I need to get the average). So it should find the average of 6, 5 , 3 , 3 , and 1.
Is there a way to do this?
Thanks in advance.
Bookmarks