Hello there
I need to find that average for data that is related to a column of data. For example
column A column B
1 45
1 23
3 5
2 43
4 12
2 32
I need to find the average of column B for all rows that relate to column A where number is 2 in column A
If I did it for 2 the average should be 43+32=75/2=37.5
It there a way to do that with a forumla?
I would apperiate any suggestions
I need to find that average for data that is related to a column of data. For example
column A column B
1 45
1 23
3 5
2 43
4 12
2 32
I need to find the average of column B for all rows that relate to column A where number is 2 in column A
If I did it for 2 the average should be 43+32=75/2=37.5
It there a way to do that with a forumla?
I would apperiate any suggestions