excel 2019

  1. P

    Extract text outside multiple parenthesis

    I want to extract all text outside of any parenthesis. I can get the text from the first occurence of a parenthesis using: =TRIM(LEFT(A2,FIND(" (",A2&" ("))) But now sure how to do this for multiple occurences. Below is an example. Text Expected result Cucumber (1) Cucumber Cucumber...
  2. R

    Operations Management Calculation Formula Help

    Good morning. I am working on a problem in my Operations Management class and am having a problem with a calculation formula. Question: Wanda's Car Wash & Dry is an automatic, five minute operation with a single bay. On a typical Sunday morning, cars arrive at a mean rate of 8 per hour...
  3. P

    Excel 2019 - Freely associating primary and secondary axes to series bypassing default behavior

    In Excel 2019, when adding a secondary X axis to a scatter plot graph that already has a secondary Y axis, the series previously associated to the primary X and secondary Y, become associated by default to the secondary X (the association to secondary Y axis remains). The specification of...
  4. S

    Various Instance of Excel talking to each other crash

    Hello everyone, I am working simultaneously with multiple instances of Excel, as this is a way to utilize more CPU and decrease calculation time per instance. Basically, there is one "Master" instance and several "Slave" instances. When I start the day, I first open the Master Instance, and...
  5. S

    Adding Sequence numbers based on Cell value in ColumnB through VBA

    Hi Friends, I am trying to add sequence/following numbers in ColumnA based on cell value in ColumnB. I been doing it manually, but its taking countless hours to go through thousands of rows. Thought that I can get some little help here. Attached the spreadsheet to understand more. ( Hightail...
  6. bobsan42

    Compatibility or security issues Excel 2019

    Hello everyone. I stumbled upon an issue which i can't seem to solve immediately. I am currently working on a project - automating excel as a relatively simple database. There is basically a front-end (with the intention to make it an excel add-in) and a simple xlsx as a backend. It has its own...
  7. B

    Help with pivot table

    Hi I have pivot table with 2 years of cost data for services and I have taken average cost as a sum. The issue I have is some of my data has N/A e.g cars 2019/20 £5000 cars 2018/19 N/A So when I pivot the above instead of excel taking 5000 it takes the average of two years which is £2500...
  8. T

    Excel to find key words and paste the same in Criteria column

    Team.. Need your help again. I believe it is possible for Excel to find key words as described by user and paste the same in the dedicated cell. And I also believe this can be done without using a Macro. Please help out on the below.. I prefer not to use Macro's if possible please. Keyword and...
  9. S

    Need to Transpose these 1 to 6 columns into one single Column (multiple rows),Keeping the left 2 columns intact. Please help!

    Company Name Count of Names 1 2 3 4 5 6 Deco-Mica Ltd 4 Deco Mica Ltd Deco-Mica Ltd Deco Mica Deco-Mica Bharat Textiles & Proofing Industries Ltd. 4 Bharat Textiles & Proofing Industries Ltd Bharat Textiles & Proofing Bharat Textiles & Bharat Textiles Sainik Finance & Industries...
  10. S

    How to run VBA Macro on Workbook instead of worksheet

    Hi Friends, I have 100s of Excel workbooks with single sheet in each. Every time I have to open each workbook and run the macro to do the job. I am looking to modify and run the macro on list of workbooks in folder one by one. So Macro will run through all excel files in folder one by one and...
  11. C

    "SetWindowsHookEx" Crashing Excel x64

    Hello. For a while I've been using the MsgBoxCB sub from Dan Elgaard (www.EXCELGAARD.dk) in order to have message boxes with custom button text. Up until now I have been using Excel 2007-2019 x32 and everything has been working perfectly. Recently I started testing my application on Excel 2016...
  12. M

    Last Modified UDF Row Function

    I do not know if this is possible however, what I am looking for is to modify this UDF function to show the date that a cell was last modified. Currently, it is only showing the date that the UDF is inserted, not the actual date that the cell was modified. For Example: -If I am insert the...
  13. F

    Trouble saving 2019 workbook in the hidden view

    I recently purchased a new Dell tower computer that is running Windows 10. I also purchased and installed Office 2019 Home & Student software. I created a spreadsheet with just a list of business locations on it. (no macros involved) I placed this into a folder that automatically opens this...
  14. S

    Index/Match

    I made a vlookup formula to indirectly get value from another sheet. The problem is the value i need is below two rows. I know i can't use offset in vlookup and i am not familiar with index/match. Can anyone help. The formula is =VLOOKUP($C$1,INDIRECT("'"&$B3&"'!A:AZ"),2,0) . Remember i need the...
  15. R

    Excel 2019 macros error: "Excel cannot load two files with the same name"

    Since I upgraded to Excel 2019, my existing macros will not run - they have worked for years on older Excel versions and they DO run normally on my Excel 2019 installation at the office. I use icons on the ribbon but when I click one, I get the message "Excel cannot load tow files with the same...
  16. S

    Excel VBA to cross match 2 sheets data and output into sheet3

    Hi Friends, Trying to match 2 sheets data and copy entire rows into sheet3 I been through posts on this mrexcel forum and on google search but did not find a correct vba to do the task. In sheet1 ColumnB is always blank In sheet2 ColumnE is always blank I manually copied what results should...
  17. C

    How do you count occurances of something over a period of time?

    I have a spread sheet with the following columns: <tbody> User name Date Time Time of Day Error Code Status John Doe 11/1/2016 12:25:01 AM 123 Success John Doe 11/1/2016 8:25:00 PM 123 Success Jane Doe 11/1/2017 8:25:00 AM 234 Failure </tbody> So I want to count how many times...
  18. N

    ARRAY number of rows and colums, how to know the correct values for the size...

    This is the first time I'm trying to use ARRAY's in Excel. Reference: =IF(ROWS(A$10:A10)>$D$8,"",INDEX(Gas!A$6:A$18,SMALL(IF((Gas!$A$6:$A$18>=$C$4)*(Gas!$A$6:$A$18<=$E$4),ROW(Gas!A$6:A$18)-ROW(Gas!$A$6)+1),ROWS(A$10:A10)))) For example, it seems that the reference table A6:A18 in this case...
  19. D

    Drop down data not loading when running power query

    I have 4 workbooks. Each contains two columns of data pulled from drop-down lists. When I use Power Query to combine the workbook data, everything comes over except from the two columns that contain drop-down data. How do I get Power query to pull this data over? Thank you.
  20. G

    Need guidance on finding duplicate data in a multisheet workbook

    I have a 25 sheet workbook, that I need to highlight duplicates in only 1 column (the same column) in each sheet. Each sheet has another 15 columns of other data. The data is a 4 digit number. But maybe changing that to a string of text in the future. I have tried using conditional formatting...

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