articles

  1. MrExcel

    Invitation to post articles in new Excel Articles section

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

    You Are Invited to Post Your Articles at MrExcel

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

    Golf majors; retreive data from Wikipedia articles

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

    ABC analysis

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

    Data validation, but is it possible?

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

    sending multiple email via lotus notes to specific address

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

    Using "~" (Tilde) in formula's

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

    Combination or permutation - Product numbers example

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

Watch MrExcel Video

This Week's Hot Topics

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
Top