1. D


    Hi, In power query when using the Table.FromList function, I add ; Splitter.SplitByNothing() after the source list, as it doesn't seem to work if you don't . It says in microsoft docs that the splitter is optional, I tried just putting the value null, but this doesn't work either, can...
  2. D

    HELP PLEASE! Looking to create a "Mandatory Overtime" list that rotates after the employee is held for a shift.

    Hello. I am new to the forum. I have spent about a week looking for answers and trying to solve this issue on my own. I am fairly well-versed with Excel... more so than a "general user"; however, I have little experience with coding and VBA. I have attached a mini-sheet of my list; it's pretty...
  3. C

    List items according to an attribute

    Dear Mr. and Mrs. Excels, I'm looking for a solution for the following problem: I have a huge list (28 000 rows) of items (practically document subchapter titles) that are connected to their parent items (main chapters) as follows: Chapter title Subchapter title Staring page no. 1.1...
  4. MDHolmes

    Populating a wage based on a drop-down list

    I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...
  5. B

    Merge list with several rows into new list with more columns

    Hi I have a list in excel with following columns SocialID (unique number) Name Phone number A person can have several rows since they can have 1 or 2 phone numbers. I want to merge the list into a new with these columns. SocialID Name Phonenumber 1 Phonenumber 2 How can i do this?
  6. A

    VBA for list from another coulmn each value once

    hello i need a VBA code that gives me a list in cell B20 that contains values from sheet1 coulmn B:B. if value is writen 2 times, so give it to me only once. if value is writen oce, give it to me as well. each valuse only once. thank you!
  7. A

    get any value once

    How do I get a list in the "main" sheet of entries that appear in the "data" sheet in column B, that I get each entry once! I mean there are values that appear several times, and I want to get them only once. And that I also get a value that appears only once. one of each.
  8. S

    Data validation list - the order of computing formulas

    Hello, the good example of drop down list is here: Prevent duplicates in cells where there is a dropdown list It is not working when typing allowed value, for example "peaches" and pressing enter on the keyboard. The value "peaches" is accepted when it is choose directly from the list or...
  9. T

    Flow-Chart design, If-function, macro, INSPIRATION

    Hi I´m not sure how the best way to make this Flow-Chart. We need to give this to customers, so they can get the right information. Each step has underlying data that need to be presented in a report to the customer in the end. I have thought about doing a combination of list...
  10. F

    Creating a changing data validation list

    Hi. I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words? Example. TEST1 TEST2 TEST3 etc down to TEST10. I go into another cell...
  11. M

    Filter using mutiple sheets to create an array?

    I am looking to colate a list of values which appear on multiple tabs in a work book. Sheet 1 and 2 below have varying data but not all in the same columns. ABC1NumbersLettersColours2123abcblue3456defred4789ghiyellow...
  12. A

    List arrow is not visible

    Hi I have created a simple list where you have to choose the company sector. The problem is that you cannot see that you have choices. The B2 has the arrow visible simply because I´m in the cell B2. In B3 and B4 the reader has the same choices but as I do not see any arrow at the side the reader...
  13. O

    Filter a list based on a list of terms, then copy filtered list into a new sheet

    I receive a long list of data of people I want to contact, but want to filter out the people I don't want to contact. Each row (person) will have multiple columns, one of which could be "Location" [London, Paris, New York...] I have a list of blacklisted terms, for example [Paris, Cairo...
  14. M

    Sort list by size

    Hi, i want to analyse a big amount of number and would love some help. Column A = time Column B = Price Column C = Size Aprox 200 000 rows :O How can i sort this so the 20 biggest by size show up in Column D (biggest on top) followed by it´s time in Column E and it´s price Column F. If i...
  15. D

    Splitting a list into columns

    Hi there! Hoping someone can help. So I have a table > column A has the ID, Column B has the Associate Name and column C has the badge type. What I want is to have 2 separate columns that list the names from the 2 separate badge types. How do I do this without using VBA. I'm trying to figure...
  16. G

    Passing Variable in URL (Power Query)- Loop vs Parameter

    Hello everyone, and happy almost Thanksgiving! I am working on a project in Power Query and need advice as to how I should pass a variable in my URL. The URL is for free access to an API that allows 100 combined request/day. The original URL has a spot where a UPC code can be changed to...
  17. G

    Call double click automatically in a form

    Hi everyone, Hope you good guys. Since 1 week, I try everything in my possible and nothing works... The goal ? => I have a form that lists differents values in my cells. In this list, I have a search bar and I have to double click on a item to have what I want after. When I double click, another...
  18. Akuini

    VBA Macro to create Word & Phrase Frequency

    This macro generates word & phrase frequency. You can set the number of words contained in a phrase as needed, in this part: Const sNumber As String = "1,2,3" You can also set what characters should be considered as word characters, in this part: Const xPattern As String = "A-Z0-9_'" but...
  19. N

    Create Single Cell Lists from Text Strings With ';' Semi-Colon Delimiter

    I would like to build a list within a single cell from a sting stored another cell. The string has a semi colon delimiter ';' to separate the string SMTP, smtp, X400, FAX. Unfortunately the x400 portion of the string also has semi colons which need to be kept. Its delimiter is a second semi...
  20. S

    Populating data from another sheet from list then clearing after viewing

    Hello, So I have an interesting problem, I am making a maintenance list for many machines and tools. I would like the first sheet of my workbook to be the only visible sheet in the workbook and everything else to be hidden. I have already made it so I have another sheet that is a so called...
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
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 "".
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