Range name

Hi everyone,

I have a question about the range name and description.

When I use formula with another sheet it calls automatically like {range Count}.

Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not mentioned in the range name.

Could you please share with me whether it is possible to find the description of the range in { } somewhere?

For example: {range Count} = sheet "Name", range "Count:Count"?

Thank you!

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Kseniya,

The only places where you can see the reference is in the formula, or when you click on a cell, that's part of the formula. If you click on the links "Edit Reference" you'll open the "Reference Another Sheet" window where you can see and update the range.

It's also a best practice to rename the references to something better, so it's easier to work with.

You can optionally type a name for your reference. (If you don’t enter a name, the reference will be assigned a default name based on the sheet name and the number of times that sheet has been referenced.)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Kseniya Bondarenko

Thank you, it has really helped!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Paul Newcome

I rename all of my references to "Sheet Name - Column Name" unless the range is not an entire column. In those cases I will use something specific to that range such as Row Number or even "Sheet Name - [Column Name]#:[Other Column Name]##".

If I am getting errors in my formulas I will use what Andree suggested and click on the "Edit Reference" link. When the sheet comes up, it will have a bold box around the range so you can make sure you actually selected the correct cells.

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…