named

  1. G

    Loop through list of Range Names in two columns

    Hi Folks, I'm trying to figure out if there is a more efficient way of doing the following. I have a bunch of named ranges for two different variables that I use a drop down to select (well a dropdown that selects a name that then references the named range and puts its data in the correct...
  2. G

    Return Named Range Value using Radio Button

    Hi there, I am trying to figure out how to return an item from a named range using a radio button on a different worksheet. Ideally, I'd like to be able to return a single item and then in another separate instance return a whole array. So below, the single item example would be click one...
  3. G

    Named Range - unwanted @ and spill blocker show up when reopening a file.

    Hi Gurus, I have a defined name referencing a column in a worksheet that is actively calculated. It is called _5yrDates and is simply Today() - 5 years. Other sheets use this name to grab the same data. When I close and reopen my file and click on the first cell in the named range, it has an @...
  4. S

    Named Formula?

    Hi, Firstly I don't believe this is possible but thought I'd check. Is there a way to name a formula, so like how a named range works but for formulas so say "INDEX 1" could refer to a long index formula to shorten the characters in the formula box. Thanks, Paul
  5. W

    Sum the entire column of named range except the first row

    Hi Folks, I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to...
  6. L

    SUM by Week

    I want to enter a formula in sheet name "calculation" B4 that if the Date in Sheet named "Raw Data" Header named "Date" is withing the week 44 date that in the Sheet named "Calculation" D2 sum the data in the sheet named "Raw Data" heater named "Count of Assets in BU"
  7. L

    if text equal count

    I need a formula that i can put in a sheet named Calculation B:54 that if in sheet named Raw Data anywhere column D there the words "AIM 2019" it will add the total numbers in Column G of sheet named Raw Data.
  8. M

    Name manager - adding data manually as reference

    Hello, Normally we create named ranges by referring to excel lists - we select the data range that is located in certain cells in worksheets. I tried to create named ranges by manually adding data to "refer to" part. But it didn't work - all the data that I added appeared in one cell, so not...
  9. A

    Consolidate Multiple Named Ranges Into One Pivot Table In Excel

    Hi all, I am having trouble with the consolidation of my named ranges into the one pivot table to finish a dashboard. I have got all the named ranges into the data source. Each named range is the same shape: that is, each consists of 4 columns. Columns are Amount, Animal, Location, and Colour. I...
  10. S

    Automatically typing the whole list by the list name

    Hi there, I have stucked in the above said. I have named the lists. Like 12 different training given in April month, I named the training list by "April". Now I want to show it like if I select "April" in a drop down list, the names of all training should come in next or desired cells by list...
  11. L

    Copy date from a different Sheet

    I want to be able to copy data from a different sheet to a specific feel in a another sheet. I have a sheet named GSO Inventory Stats and a sheet named Retag metrics. I need to put a formula in Column I, that if Column H in sheet GSO Inventory Stats matches the sheet named Retag Metrics Column...
  12. S

    Delete ranged names

    So I have an interesting one for you all. I have a master workbook I made for a gradesheet and put it in the public folder. When a new class starts the instructor will make a new folder for that class and copy the master book into that folder. It is still in beta mode, so as the classes have...
  13. L

    Copy Data From Sheets

    I have a Sheet Named NEA Status and a sheet Named Inventory Stats I want that if Column D in Sheet named NEA Status Matches Column D in the sheet named Inventory Stats move the data from Column H in the sheet Named Inventory Stats to Column H in the sheet named NEA Status.
  14. C

    Return cell value based of row Named Range and Column Named Range

    Hi All I want to return the cross reference of 2 named ranges. There is a sheet called Front Page where i want to return the result and the information is on a sheet called Commission Row named range = Partner Column named range = Finance Both of the named ranges will be referenced in as...
  15. T

    Collapse/Expand grouped columns based on cell value

    Hi All, I have a worksheet with 52 weeks of personnel planning. These are grouped columns with an empty column in between each week. The groups are in columns E:PL. Each of the weeks are named ranges. Columns A:D have text (ie. work path, area, etc.). For the user, the columns are frozen to...
  16. A

    Referencing Drop-down list error #n/a

    Hello, I have a multi-sheet workbook and I am having problems with a cell in sheet 1 that references another cell in sheet 2. That second cell is populated by means of a drop-down list and I’m sure that’s where my problem lies but I don’t know how to fix it. I keep getting the #N/A error...
  17. L

    Indirect Function Alternative

    I started using the INDIRECT function to create a super dynamic Sumif that references a named range based on criteria. However, I noticed that my calculation time has increased significantly since taking this approach. I read online that this is a very volatile function that performs slowly...
  18. G

    Delete all defined named ranges from a selection

    Is there a way to delete all named ranges from a selection? Here is the selection that I am trying to delete the named ranged from: Range("CompOverviewTable[[#Headers],[Competitor_one]]").Select Range(Selection, Selection.End(xlToRight)).Offset(-1, 0).Select
  19. J

    How to find where a named range is being used for data validation or as a rowsource?

    I have a named range in a large spreadsheet that I suspect is being used for either a) data validation for some cell or b) as a rowsource for some combobox on a userform. Is there a "simple" way to find out where exactly it's being used? My understanding is that trace dependents will only check...
  20. T

    Matching value in Range("A5") against a list of items

    Hello, I have a script with an IF Range("A" & r) value is also in a lookup list AND Range("I" & r) THEN do something. I know I can do a bunch of ORs but that doesn't seem particularly neat. IF Range("A" & r) is in Lookup list named Type AND Range("I" & r) IS NULL Then DoSomething. Any ideas...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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