list

Hello, (First; I have Office 2016 at home) I want to run a statistical analysis on my photos that I have taken over the years to see what my most used focal lengths are. The focal lenght in the EXIF data is available for windows explorer and can be seen like this: In excel, I just learned...

Hi - I wanted to see what the best method is to find a value in a pipe-delimited string in one cell that matches a value from a list and extract that value. Example: Metric Pipe Delimited Values 3 112356|229531|229327|229533|229532 5...

I would like to copy from Cells O4:O9 in Sheet 1. The destination would be a transposed paste result into A1:F1 in Sheet 2. I would like the information to remain their temporarily. Then, if I run the macro again, I would like it to copy the new data in O4:O9, but this time paste into A2:F2 on...

Hello, I'm not having any luck using wildcards to return values from a table of data based on a list in a Named Range. I'm using the following to return a list of books that are part of a given Series. However, due to multiple values in the Series column, I need to be able to use wildcards...

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...

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...

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...

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...

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...

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=...

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 =...

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...

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...

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...

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...

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...

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...

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]

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")

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...