Search:

Type: Posts; User: MrExcel; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    8
    Views
    7,069

    Re: What is XLookup?

    XLOOKUP is an amazing new replacement for VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, even INDEX-MATCH-MATCH. It was released on August 28, 2019. The curious part is how our OP heard about this back in...
  2. Replies
    11
    Views
    2,129

    Re: Firefox asks to open / save file (???)

    Thanks for reporting this very annoying problem! It was happening to me in Chrome ... a zero-length file download. Nothing here should be downloading anything to your computer.

    Our ad partner...
  3. Replies
    4
    Views
    71,206

    Re: Convert to Proper case with VBA

    Hello everyone. Sorry to resurrect an ancient thread. One of my good friends using Excel on a Mac says that this may not be working on the Mac platform here in 2019.

    Rather than StrConv, I...
  4. Replies
    2
    Views
    1,105

    Re: Happy birthday bill jelen!

    Thanks! With our move to Florida, the usual birthday cake was replaced by Key Lime Pie!
  5. Re: I had Easy-XL - lost it when updating to Excel 2019.

    Write to John West at this address: Support at InformationActive dot com and identify yourself as an Easy-XL customer. John will help.

    Bill
  6. Replies
    15
    Views
    3,027

    It was twenty years ago today...

    On November 21, 1998 I posted the first answer at MrExcel.com. A simple little formula of =A2-DAY(A2)+1 got this whole thing started.

    It is amazing that the community here has posted over 1...
  7. Re: project files from "VBA and Macros for Microsoft Excel"

    Hello Luis

    Are you downloading from: https://www.mrexcel.com/download-center/vba-and-macros-microsoft-excel-2010/
    1. Can you download the zip file?
    2. Can you unzip the file?
    3. When you go to...
  8. Replies
    2
    Views
    7,871

    Re: Easy-XL Website Can't be reached

    The product has been discontinued for over two years. The old easy-xl product is now known as ActiveData Business Edition
  9. Replies
    10
    Views
    3,100

    Dynamic Arrays Debut September 24

    Microsoft just announced Dynamic Arrays for Excel.

    They say that Ctrl+Shift+Enter will not have to be used anymore.

    It is the 4th item on this page:...
  10. Replies
    4
    Views
    6,050

    Re: Excel slicer keyboard shortcuts?

    I am adding to this old thread because I arrived here when trying to figure out how to activate a slicer without using the Mouse. I finally figured it out. It is very subtle and I wanted to document...
  11. Replies
    23
    Views
    2,989

    Re: Attachments redux

    Thanks RoryA

    vBulletin5 would crush under the weight of the database we have here. It is not being considered.
  12. Replies
    23
    Views
    2,989

    Re: Attachments redux

    Hi Jennifer,

    You make a compelling case for including images.

    vBulletin has two ways to store images: In the database table and in a file structure. I made a bad choice 15 years ago by storing...
  13. Replies
    3
    Views
    25,488

    Re: Excel - Moving dotted line not going away

    Let me provide some backstory on this. The behavior changed for Office 365 customers starting in June 2017. Acting in response to this request on Excel.UserVoice, the Excel team changed what events...
  14. Re: Selecting cells in worksheet with a printable background - how to

    Brilliant. Thanks for suggesting it.

    Bill
  15. Re: BIG DATA ANALYSIS: Mrexcel, A GREAT WONDER!!

    Thanks for your note. I tell people that simply reading threads here will make you better at Excel. It is like watching a queue of people climb a mountain to visit the greatest Excel gurus. Watching...
  16. Replies
    1
    Views
    10,129

    Sticky: Re: Request for excel spreadsheet file

    Thanks for watching the videos.

    I know that other channels such as ExcelisFun offers workbooks for every video. I have not been in the habit of doing this. At this point, with 2100 videos out...
  17. Re: Massive problem: Excel has found unreadable content.

    I will echo Jon on this point. The bug hit the insider builds for about 18 days before it was fixed. The first N times it happened, I simply Ctrl+Alt+Delete and lost my work.

    But 9 time out of...
  18. Replies
    8
    Views
    2,468

    Re: The big 1,000,000!

    I definitely want to do something to commemorate the 20th anniversary on November 21. But I don't know what yet. Any ideas?
  19. Replies
    23
    Views
    10,701

    Re: Regression Analysis.

    This old thread is still getting some hits. I ran across a utility from 5DChart that will compute the best fit plane equation using least squares, and to display a 3D regression plane directly in...
  20. Replies
    4
    Views
    1,073

    Re: Excel 2016 VBA & MACROS - Content Update

    Derek is correct - with no changes to VBA - there has been nothing to update in the book.

    Bill
  21. Re: VBA Find Entries Dated Within Next 7 Days And Copy Matching Rows Into Another Workbook

    Would you consider this:
    1) Have the macro code sitting inside the destination workbook
    2) To run the macro, you would open the destination workbook and keep it open in the background. You would...
  22. Re: Moving Weighted Average Between Timestamps

    To restate this, you have a series of entries in Column A and then time stamps in column B.

    You want to average the last ten time stamps.

    If I could tell you that the last time stamp is in cell...
  23. Replies
    53
    Views
    15,097

    Re: New Forum Features July 31 2017

    Hi Dave

    I often tell a story in my seminars about the community here... the OP will think that the first answer is a suitable answer and goes back to work. But after the OP has left, some of the...
  24. Replies
    53
    Views
    15,097

    Re: New Forum Features July 31 2017

    Yes - I removed the Dislike flag. I want to say it was a stupid feature to begin with. The new system does allow for any custom text, so we can have things other than Like and Thank, and they can all...
  25. Re: VBA merging a specific sheet to another workbook

    It would help us if you can write a few sentences about what you are trying to do, rather than asking us to interpret 50+ lines of code to figure out what you want to do.

    It looks like you are...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4