In a table I have:
cell A1 is the persons name
Cell A2 in an amount of time such as 5.00
there are people but over 100 entry’s. I.e. each person has multiple entry’s.
what formula could I use to produce a summary let’s say one of the persons Name was Dave (in column A)
In column C I want it to show me a list of the names (5 people) and next to their name their AVERAGE time in column D
i.e. Dave 4.35
here’s the catch. If I add another name and time to the original list I want a summary of that person to automatically appear in column c and d
is this possible? Would it be an array formula?
cell A1 is the persons name
Cell A2 in an amount of time such as 5.00
there are people but over 100 entry’s. I.e. each person has multiple entry’s.
what formula could I use to produce a summary let’s say one of the persons Name was Dave (in column A)
In column C I want it to show me a list of the names (5 people) and next to their name their AVERAGE time in column D
i.e. Dave 4.35
here’s the catch. If I add another name and time to the original list I want a summary of that person to automatically appear in column c and d
is this possible? Would it be an array formula?