list

  1. A

    Find and Replace Value in List Named Range Reference

    I am making a bracket for basketball teams by region. I select the winner of the game based on a list referencing the named ranges you see pasted below. I pull data from multiple web queries into each regional bracket and have many formulas. Because of this, its quicker to copy the sheet and...
  2. Chris_010101

    Mail merge with list numbers

    Hello, I am trying to create a mail merge spreadsheet which I can use to create employment contracts. Everyone in the company is on the same employment contract and the only difference is the notice period, as follows: Manager During your probationary period, your employment will be subject...
  3. R

    Data Validation Drop Down List - Allow Duplicates

    Hi I am hoping someone will know this. I have a data validation list for a change of a product outside of the generic product, meaning I want the first item on the list to be a = to the main generic product (which changes to other products on the list) and the rest of the items are all the...
  4. K

    Compile List

    Hi everyone, I created a workbook that records all the deficiencies that are in one building. There are currently 100 units and each unit has its list of deficiencies that need to be completed by the appropriate trade. I would like to create a separate worksheet for each trade that compiles...
  5. T

    One column list from multiple columns

    Hi ... I've got this Excel sheet contaning 29 columns from E:AG with different words. You see, the norwegian alphabet has 29 letters. Columns varying from a 100 rows to a few hundred thousand. I want to, in a search cell, type for example, ??rem??, and get a one column list of all seven...
  6. S

    Convert table to list (Number)

    Hi I have the following code to convert sheet range to number in power query, The range named "Tests" would accept any thing except number. I know there is minor change I have to do, but I couldn't figure it out. let Source = Excel.CurrentWorkbook(){[Name= "Tests"]}[Content], MyList=...
  7. F

    VBA to duplicate and name sheet according to list

    Hi, I have the following VBA Sub CopyTemplate() Dim wTemplate As Worksheet Dim wLIST As Worksheet Dim wCopy As Worksheet Dim r As Long Dim m As Long Application.ScreenUpdating = False Set wTemplate = Worksheets("Template") Set wLIST = Worksheets("Lookup") m =...
  8. B

    Impossible to make a recurring sequence of strings with skips?

    Hi, I've been trying to make a list in excel that looks somewhat like this. Week 1 ...... Week 2 ..... Week 2 ...... Week 3 .... Week 3 .... Week 4 .... Skip Week 1 Week 4 ..... Week 1 ..... Skip But I've run amuck every single time. It's hard because i'm trying...
  9. I

    VBA macro for REPLACE cell value from a list THEN print in a single PDF Document!

    I found in this forum how to printout sheets with different values, but I'd like to print all the sheets in a single PDF Document. How can I fix this VBA code to do this? Sub PrintAll() Dim i As Long, LastRow As Long LastRow = Worksheets("Names").Range("A65536").End(xlUp).Row For i = 1 To...
  10. SkywardPalm

    Trying to write data validation for if there is a certain value in AC column, a dropdown (that's based on a certain range) appears in AD column

    Anything I try gives me the error "the list source must be a delimited list, or reference to single row or column" What I have now is something like =IFERROR(CHOOSE(IF($AC1="Update Location",1,IF($AC1="Update Source",2)),SUMMARY!$B$17:$B$226,Master!$X$2:$X$1048576),"") where if Update...
  11. V

    How can I simplify this?

    Hi, New to vba and using it to make macros. I built a macro based off one I found online. It's designed to delete rows if they have certain criteria, but each criteria is in separate auto filter section. Is there a way to list all of the criteria(TV show names) in one "section" ? Sub...
  12. T

    Faster Alternative to Conditional Running Total than List.Sum

    Hello everyone, I'm trying to add a column that will sum up values in another column based on a few conditions. The code I currently have uses List.Sum. I have to do a similar conditional running total calculation several times in my query along with a few other transformations. The query...
  13. S

    List alpha numeric numbers between two references

    I found this by Snakehips and it was VERY helpful ! I tried to modify it but found that it only works with numeric entries and not alpha numeric entries. Rich (BB code): Sub Fill() [A4] = [A1].Value ato = [B1].Value [B4] = [A2].Value bto = [B2].Value [C4] = [A3].Value...
  14. D

    If Substring from a List contains Subtring, return that item from the list

    I have a column containing broken/good domains I want to compare it to a list containing all the correct domains, and return those from this list that partial matches with [Email Domain]
  15. D

    Text.Contains with List Parameter

    I want to check if each column value contains a substring of each value in a list, and output "FOUND" if true. Current Code: = Table.AddColumn(#"Source", "TEST", each if Text.Contains([Email Domain], RandomList) = true then "Found" else "Invalid")
  16. D

    List.ContainsAny not working in List.Accumulate

    If I use Text.Contains to have 1 filter only, it works fine (e.g. only those containing "@"). However, I want to combine the filters into 1 query so there won't be so many steps. Therefore, I'm using List.ContainsAny instead. I think it's because PQ cannot pick up List.Accumulate's "current" if...
  17. D

    Trying to make a form that will auto update values on different sheet

    I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...
  18. D

    Convert each row to List

    How do I convert each row into a list without adding a new column? What I have so far: = Table.TransformColumns(TESTT, each Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)([TESTT])) It gives error: Expression.Error: We cannot convert a value of type Function to type List. Details...
  19. C

    Follow-up List

    I attached photos. I have a spreadsheet with multiple rows containing criteria to be met or unmet, and then columns pertaining to persons who have either met or unmet the criteria in the rows. What I would like to do is create a follow-up sheet that autopopulates any unmet items. The...
  20. D

    List.ContainsAny within same column

    I'm trying to check each list if any of its content matches any other lists' contents, and then flag them if found e.g. for each List in Time if List.ContainsAny(Current List, Any List from time column) then flag repeat for all...

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