excel 2019

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

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

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

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

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

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

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

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

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

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

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

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.

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

When I go into Power Pivot in Excel 2016 and Excel 2019 and select Get External Data From Other Sources I get nothing, no Table Import Wizard. Any ideals why? Thank you!