1. U

    Inserted row above total is not included in total. Any solution would be welcomed!

    I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total. I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...
  2. N

    Excel VBA Date Picker for win64 bit

    Hello, I'm using Microsoft Office 16 in windows 10 / 64bit I'm looking for a solution to have a popup date picker in my userform I'v been searching for a solution long time ago, found a lot of solutions but most of them for 32bit, and some for 64bit but none of them worked correctly Please I...
  3. H

    Number changing to date

    I have this age old problem in many excel files When I open excel file, numbers gets change to date. This does not happens everyday but happens sometimes on some day, in some sheets in some rows. But whenever it happens it spoils by half day. I tried lots of solution, like changing cells...
  4. S

    Pulling Latest value for each ID via vba

    Hi Guys, Basically I have a fairly large spreadsheet which contains ID's and then values in the adjacent column with dates in the following column. For each ID I want to take the value corresponding to the latest date, bearing in mind each ID could have a different number of values and...
  5. H

    Formula to extract characters from text string

    Hi mrexcel forum, Could you please suggest a formula to help me with this issue? Issue A: I will like to extract out the numbers immediately before and after the dot. This is the volume information. Issue B: I will like to extract the 3 characters immediately after the Volume information...
  6. J

    Drop Down List Based On A Cell Value

    Hi, I'm looking for some help with drop down lists....or any other suggesstions are welcome! So in a table, a cell will be populated with a number value and i need the input of another cell to be restricted based on that value. The restriction will be above or below 10,000. I was thinking...
  7. K

    Question on Solver

    I am trying to run the code below. When I run this, I am getting the following error message: OpenSolver Could not find an optimal solution, and reported: Infeasible The Model contains a restraint 'I2:I160 >=1' for which instance 4does not depend on the decision variable and is not satisfied...
  8. H


    I am performing an if formula that has 2 AND criteria, fo which one is a contains wildcard. I read that countifs may be the solution but I am still off the mark Can anyone help please? Many thanks
  9. S

    Run-time error 3343 - Is there a solution

    I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...
  10. H

    Capture Highest & Lowest Value

    B2 gets updated by values due RTD B3 I have kept a flag which becomes 1 for a certain time period (ONLY ONCE DURING A DAY) Solution required: B4=HIGHEST VALUE of B2 when B3=1 else 0 B5= LOWEST VALUE of B2 when B3=1 else 0 How to accomplish? Thanks in adv
  11. R

    Solution Appreciated

    Extremely large data set that will include the following information. Is there a simple method (formula) to provide the following summation (for a large data set,A1:A200, etc.)? <colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="64"...
  12. R

    Count number of times a specific text appears in a string & range

    I hope someone can help with this problem I am failing to find a solution for. I wish to count the number of times a specific text value appears in a range. The text itself will often be part of a string which will contain other information. Below is an example of the issue I am...
  13. Mel Smith

    Sharing linked workbooks

    I have a number of linked workbooks that I need to share with one, or possibly two, other team members. We work in different locations. I have trialled sharing these workbooks with one colleague via OneDrive, which wasn’t without some problems but I wonder if there is a better/smarter solution...
  14. A

    Problem with .References.AddFromFile

    Hi members I have a trouble when I add references from file path using vbProj.References.AddFromFile "C:\Windows\SysWOW64\ieframe.dll" and vbProj.References.AddFromFile "C:\Windows\SysWOW64\mshtml.tlb" I receive a message "No se puede entrar en tiempo de interrupción en este momento" Also...
  15. P

    Iterative Process to get Values to Average 15

    I have a list of items ordered by a value representing years left and an value attached for each item. I need to determine if there is an easy method of choosing a range with an average age (say 15 Years in my example) and seeing what the average item value is for that group. At the moment I am...
  16. D

    Convert ddmmyy to Qtr yy

    Afternoon Ppl, need some help here, how do i convert eg 25122019 (ddmmyyyy) or 251219 (ddmmyy) to show its Qtr4 19 ? Any solution to this ? Much thanks.
  17. J

    Copying All Worksheets after Sheet4 (position) into a new .xlsx workbook

    I have a workbook that will have a dozen or so sheets that will vary in name on a regular basis. I want to be able to copy all sheets after the fourth sheet into a new .xlsx workbook. I have looked for a solution, but all I find is Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select...
  18. S

    Concatenate formula.

    I'm looking for a formula in cell D1 and down, that will add 1 or 2 "0" in front of the ( digit or number ) that when I "concatenate" them together from cell A1 with B1 see picture or is there another solution ? Thank you
  19. J

    Returning Data from multiple Worksheets

    Hi Friends, I’m not sure if this is possible using standard Pivots or Functions, but if it is then I know someone on here will have the solution. Basically I would like Excel to return rows of Data based on a single Criteria, but with the difficulty of being across multiple Worksheets (or...
  20. R

    Copy Worksheet as Data with Charts

    Hi all, I have been reading a lot of content here over the years and would like to congratulate the helpful community for the fantastically helpful work all of you have provided here. How, I am posting here for the first time, as I can't find a solution to my problem using the search function...

Some videos you may like

This Week's Hot Topics