Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-15-2025, 08:01 AM
ArviLaanemets ArviLaanemets is offline Excel 2003 formulas - Is there a more-readable way to use names in place of literal cell references? Windows 8 Excel 2003 formulas - Is there a more-readable way to use names in place of literal cell references? Office 2016
Expert
 
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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.
Reply With Quote
 



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
Excel 2003 formulas - Is there a more-readable way to use names in place of literal cell references? documents lost upgrading from words2000 to words 2003 reuven1925 Office 1 09-01-2011 05:28 AM
Excel 2003 formulas - Is there a more-readable way to use names in place of literal cell references? Another general question upgrading from Office 2003 to 2010 Ckingfly Office 2 01-09-2011 03:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft