mrexcel

  1. R

    Compare sentences in 2 cells and retrieve missing values

    I have 2 cells containing sentences(out of which 1 is right answer and another is wrong). What I want is to find out is the missing words in the wrong answer when compared to right answer. Example: Cell A1(Right Answer): We strongly recommend enabling push notifications on this device. Cell...
  2. Jyggalag

    IFBLANK formula but with specific text as well

    Hi all! I have this formula: But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell. Can...
  3. S

    Conditional value selection , help needed

    Hello Experts, Below is my logic to copy/paste and sort data between two excel sheets. Logic: Want to copy A2 to D31 in XL “116132” to B16 of “2” Want to copy I2 to I31 in XL “116132” to F16 of “2” Till here we bring in all data inside XL we need Then I need to sort the data in XL...
  4. T

    Countif date range AND Countif col in same row isnotblank.

    Long time Reader First Time Pleader - Guy I hope none has asked this same question exactly. I have a 1400 fields in db object- i need the count of fields usage from the fields inception date. Table one: Column A is the field Name then Created date field and then countif range from table two...
  5. T

    Generate Unique Serial Number

    i want to be able to click "Generate ClientID" it generates a unique serial number that range from 1000 to 99999 and doesn't repeat
  6. P

    Complex VLOOKUP that would return certain Percentage as a result

    Good day MrExcel First off, thank you for taking this time to open and read up until this line... now my problem st I previously posted a question similar to this here in MrExcel and it was resolved by user <strike>AliGW. </strike>Now, I have encountered a project which has a different...
  7. vds1

    Where is Andrew Poulsom - MrExcel MVP ?

    Hello Folks, Andrew Poulsom - MrExcel MVP last activity shows May 21st, 2017. He was my guru in Excel with Total post of 73,092. I was wondering if anyone knows about his well being. Thanks, VDS
  8. H

    Past hack of this website user data. Why not informed?

    Would an Admin or the site owner like to answer this question please? Regarding: Hack of MrExcel https://monitor.firefox.com/breach-details/MrExcel Why was there no notification sent from this site, at least I was never sent an email about this? Why wasn't a PM sent within the site which I...
  9. cnestg8r

    Broken link to MrExcel LX companion files

    Link from mobi version doesn't work.
  10. C

    MrExcel HTMLMaker installed but not showing on Ribbon

    I've installed (to XL2007 on PC laptop with Win10) and activated the MrExcel HTMLMaker Add-In as described on the Forum Rules page, and added the folder location as a Trusted Location, but still do NOT see it appear in the Add-Ins menu. :confused: :mad: I can see the XLAM project in the VBE...
  11. V

    VB.Net tutorial

    Hi All, Very Happy New Year. As my experience to learn VBA with MrExcel is outstanding. And hence MrExcel Experts are Programmers and hence you can guide me on Vb.net tutorial. Could any one have idea the simple and best link or document to learn vb.net, please.. Many Thanks..
  12. N

    Post does not appear

    Hi,Today morning I create a new thread and post my problem with the VBA code.But unfortunately it does not appear in MrExcel forum and also when I checked my latest post option it displays me an old post.And I tried to post it a several times.How do I solve this?
  13. B

    Where to find instructions for MrExcel HTML Maker

    Where do I find instructions for using MrExcel HTML Maker? I've searched and can only find download details. I've installed it and it appears on the menu. I highlight the range but the "Generate HTML (Specify Option)" is always grayed out. TIA Bob
  14. K

    Auto hide & show rows in excel 2013 password protected sheet

    Greetings Mrexcel, I am new in this forum and i asked a question about above title but I can't receive the answer being sent to me Mrexcel and the reason am getting is that my inbox is full ,i surely don't know what to as all my inboxes are empty. Please help me receive that answer to my...
  15. D

    New to MrExcel and How to post code

    I'm trying to learn how to post code etc before I use this site and not having any luck. I tried to download MREXCEL HTML Maker but do not have Addin folder? (that's a question i don't know how to answer). Testing post of code below seems ok but would like to show output from excel table. Any...
  16. JenniferMurphy

    Can't get MrExcel HTML Maker to work on my Excel 2007

    I am trying to get the MrExcel HTML Maker add-in to work on my Excel 2007 system. I've downloaded the install ZIP file, unzipped it, copied it to the add-in folder, and added it to the add-in list. If I click File | Excel Options | Add-Ins, I see it listed at the top under "Active Application...
  17. P

    BIG DATA ANALYSIS: Mrexcel, A GREAT WONDER!!

    Dear Mrexcelians. When I look back at where I was before I discovered Mrexcel, IT WAS TOTAL DARKNESS .....LITERALLY!! Am ready to market this site FOR ITS SUPER-EXCEL EXPERTISE, ITS AWESOME READING OTHER USERS' QUIZZES & ASNWERS. God Bless Mrexce Regards Patrick Nyaga
  18. A

    MrR or equivalent of MrExel but for R

    Is there a forum that is as awesome as MrExcel but for R?
  19. P

    MrExcel MVP

    Hi MVPs What does it take to become a MrExcel MVP?? Any self-study resources?? I admire you, MrExcel MVPs Regards Patrick
  20. S

    EXCEL LINK with ACCESS

    Can I use Access data base Data in using Excel formula?? If Can Please assist me how to do it??:mad::mad:

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
Back
Top