![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
|||
|
|||
|
Instead regular table, use Defined Table (Insert>Table)
Then, in case the formula will be in same table, you can refer to cell in same row, like =[@Status] (where Status is the example name for header of referred column) In case the formula will not be in same table, you can refer to cell of any Defined Table in same row as the current row for your formula, like =tTest[@Status] where tTest is the example of name of Defined Table You also can refer to whole column of Defined Table, like =COUNTA(tTest[Status]) Or to column header of Defined Table, like =tTest[[#Headers];[Status]] etc. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unable to see names in merge since upgrading to Word 2016 | thelighthouse | Mail Merge | 2 | 06-21-2017 06:55 AM |
| Convert cell with formula to literal value | JoyLearner | Excel | 5 | 05-31-2017 09:30 AM |
| Do I stand to gain productivity overall by upgrading to Word 2007/2010 from 2003? | New Daddy | Word | 3 | 11-27-2012 03:24 PM |
documents lost upgrading from words2000 to words 2003
|
reuven1925 | Office | 1 | 09-01-2011 05:28 AM |
Another general question upgrading from Office 2003 to 2010
|
Ckingfly | Office | 2 | 01-09-2011 03:27 PM |