absolute structured references in excel table formulas?

INKLO708

Banned user
Joined
Aug 15, 2020
Messages
21
Office Version
  1. 2016
Platform
  1. Windows
HY,
I am stucked with the absolute structured references in excel table formulas,
currently i am using this formula for calculation as......... =ROWS($Z$8:Z20) .......while in case of table calculation this looks like as.........=ROWS([@[SR NO.]]) ...just unable to to lock thse cell.
and i need this to convert into absolute references in case of table ????

guide me this plz i need to done this absolute reference.
thanks
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

LazyBug

Board Regular
Joined
Feb 28, 2020
Messages
158
Office Version
  1. 2010
Platform
  1. Windows
Hello!
Nope! In most cases no need to return to a range structure if you have a table one.
Formulas become more readable, the names are fixed. And entering formulas anywhere in an empty column will auto-copy to entire column!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,383
Office Version
  1. 365
Platform
  1. Windows
guide me this plz i need to done this absolute reference.
You will need to give a much clearer description of exactly what you have and what you are trying to do. Giving half-formulas that are not working for you gives us little to go on.

Can you use XL2BB to post a small sample structured table and explain in relation to that what you are trying to achieve?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,147
Messages
5,623,008
Members
415,946
Latest member
bellerom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top