articles

I frequently discover something cool in Excel and need a place to document it. This allows others to benefit and also provides a way that I can find it later. Sometimes, that means a video on YouTube. But other times, I want to take a few minutes to put something on the web, maybe with a few...

The migration of the MrExcel Message Board to Xenforo has consumed the better part of 2019. But now that we have migrated, I would like to take advantage of the excellent editor that we have in the new software. I frequently meet a person or co-worker in real life who has an Excel question. In...

Can someone please help me? I am trying to use PowerQuery to create a table in Excel of all the golf majors. I wish to extract their dates from the Wikipedia articles for each tournament. For example, from this web address https://en.wikipedia.org/wiki/1895_U.S._Open_(golf) I want the...

As the title suggests im working on an ABC-analysis, and since I'm here, naturally I need some help/advice/tips.. Link o sheet: https://1drv.ms/x/s!Asdl-iuZDQdchJ0h1ICV0Vx9usUQ0A If you don't know what an ABC-analysis does, it sorts "thing" after useage/cost/worth etc. (whatever you would like...

Hello, I need a data validation to go in column A which have names of the articles . These names of articles in column A will have the first character capitalized and the very next one should be non-capitalized. The third character is of no importance and hence no data validation require for...

hello , I have a xlsm file that is extracting some data from SAP system about some articles , the ideea is that when we have some changes for part of the articles we need to send a information emai via lotus notes with te changes , now the problem that we have is that not all the articles are...

I'm doing an "Index(Match)" command and my data has an "*" in the actual values. Example Table 1 Col "A" contains *1234, 12345, *1237 and Table 2 Col "A" has *4528, 12345, *1234 with Col "B"" has the return value I need. The formula I would normally use is: =INDEX('TABLE B'!A:B,MATCH('TABLE...

Hello to everybody I am looking whole day for solution for my problem with combination in excel, but i didnt sucess. So i am turning here on professionals :) My excel skills are on basic level to compare with yours. I have prepared example case, let me show you my problem: I have some...