Hi all,

Hope you are having a splendid day.

I'm trying to create a small table that will feed a pie chart to show the top five categories. This small table feeds off a much larger table and uses the LARGE formula to find the largest 5 categories and return that value. I would like to use formulas to obtain the names of the categories for use as labels in the pie chart, which are 13 columns to the left.

All this seems quite simple but I can't quite get it to work. I understand LARGE returns the value and not the cell reference so I've tried combining it with ADDRESS, so I can use it in OFFSET, but I just get an error that something is wrong with my formula or that too few arguments have been entered.

LARGE formula: =LARGE($O$18:$O$56,1)

My poor attempt returning an error: =OFFSET(ADDRESS(LARGE($O$18:$O$56,1)),0,-13))

I've also tried CELL, but think I'm missing how these functions work. I'd like to avoid array formulas where possible as there are already quite a few in the spreadsheet.

Any help appreciated.

Thanks, TC.