Hi all,
thank you for your ospitality in this forum.
This is my first question:
Let's say i have (column A and B as follow):
A 12
B 5
C 6
A 8
D 4
D 4
A 3
C 7
B 1
A 7
A 9
D 3
C 4
B 1
I need to calculate average for text value A in column B (but not the whole average of the column for A (5 entries), only the LAST 3 (or N values) entries for A so -> 9-7-3). So the result should be 19/3=6,3333. Hope i was clear! Thank you for your help!