Dynamic Ranged Names

Virgin

New Member
Joined
Jan 13, 2016
Messages
30
Can anyone help me?;

Workbook: "ProjectFilesChapter10"
Worksheet: "Employee"

You have a dynamic ranged name, "EmpList";

I looked up dynamic ranged names & I came up with a formula for creating a dynamic ranged name (it was the "Easy Excel" website);

I created a dynamic ranged name similar to the "Easy Excel" example;

You're example doesn't apply the formula to "EmpList";

The formula in question is something like this:
"=OFFSET($A$3, 0, 0, COUNTA($A:$A), 1)"

Also, I've been proofreading the book & some things in the project files are slightly different from what it says in the book.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
I virgin, I am not getting your query ?
Have you entered this formula in Name manager ?


Regards,
DILIPandey
 
"=OFFSET($A$3, 0, 0, COUNTA($A:$A), 1)"

It works if $A$3 is the first cell with Employee data and column A contains their list. Obviously this formula must be entered in Name Manager.
 
Affirmative...;

It works & it's doesn't work...;

I'm able to use my "dynamic named range" in a function...;
But... It doesn't appear in the named range drop down box...;
 
I was able to use my "dynamic named range" in a function...;

But, it doesn't appear in the named range drop down box (upper left part of the screen)...;
 
Affirmative...;

It works & it's doesn't work...;

I'm able to use my "dynamic named range" in a function...;
But... It doesn't appear in the named range drop down box...;

You have to look in Formulas | Name Manager.

By the way:

=OFFSET($A$3, 0, 0, COUNTA($A:$A), 1)

is not the best way to create a dynamic named range. (It doesn't even show the name of the sheet.)
 

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

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
Back
Top