Subtotal-like function for text on a filtered table

**ericbinfet** · 01-09-2014, 03:59 PM

I need some help making a set cell display whatever the results are from a filtered table, much the the subtotal function only adds the displayed sum of numerical values. I'll attach the sheet and give details.
I would like BX4 on 'Character Sheet' to display A108 on 'Start Here and Level Up'. That part is simple. Getting A108 to show whatever is displayed in the above filter is what I can't do. Of the options in the filter, only one value will be present at any time e.g. Barbarian or Assassin or Fighter, etc. But since I can't like BX4 to the displayed cell (since it can/will change), I'd like A108 to display whatever the result of the filter is. Help?

**FDibbins** · 01-09-2014, 04:27 PM

Hi and welcome ot the forum

I know you have probably put a huge amount of work into creating that sheet, but merging all those cells will cause you nothing but problems with formulas and references. All those narrow columns are a nightmare to work with too