I have this data set. I need to calculate average of top 3 of another column.
I googled, I couldn't figured out this. And more thing is there are blank cells as well in the data.
I am attaching a sample excel sheet. Please find the attachment.
Average values in Column B based on Top 3 values of Column A
Average values in Column C based on Top 3 values of Column D
Currently I am using conditional formatting to highlight the cells of top values and manually select adjacent cells to know the average. I would to have a formula for this. Any help would be appreciated.
Here is the snapshot of the data.
DlCkLy6.png
Bookmarks