Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 1 7
Impact
~28k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Sep
24
awarded  Autobiographer
Apr
7
awarded  Famous Question
Feb
7
revised Dynamically reference a Named Table Column via cell content in Excel
added two answer method receives and extra reading to make the question more valuable
Feb
7
comment Dynamically reference a Named Table Column via cell content in Excel
Excelent, i actually came across this method later on and have been using it since. Coincidentially i started noticing a huge slowdown on the older spreadsheets where i was using indirect on over a dozen sheets. Thanks!
Jul
1
awarded  Supporter
Apr
12
awarded  Notable Question
Feb
5
awarded  Popular Question
Aug
13
awarded  Scholar
Aug
13
accepted Dynamically reference a Named Table Column via cell content in Excel
Aug
13
comment Dynamically reference a Named Table Column via cell content in Excel
indeed that worked, i needed to reference the entire table. this worked! thanks!
Aug
13
comment Dynamically reference a Named Table Column via cell content in Excel
Yeah my table is properly named with the different columns, what i want is a method to TELL excel what column i want depending on a cell value, something like this =COUNT(Table1[A1]) Where A1 is the cell i want to contain the columnname
Aug
13
revised Dynamically reference a Named Table Column via cell content in Excel
clarification
Aug
13
awarded  Student
Aug
13
revised Dynamically reference a Named Table Column via cell content in Excel
changing title and clarifying question
Aug
13
comment Dynamically reference a Named Table Column via cell content in Excel
Currently using Excel 2007
Aug
13
awarded  Editor
Aug
13
revised Dynamically reference a Named Table Column via cell content in Excel
cleaning up a bit
Aug
13
asked Dynamically reference a Named Table Column via cell content in Excel
Nov
8
awarded  Tumbleweed