mrexcel

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

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

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

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

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

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

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

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

Link from mobi version doesn't work.

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

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

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?

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

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

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

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

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

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

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

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