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