Trending questions in Others

0 votes
1 answer

Comparison operator with duration that may exceed 1 day with format h:mm

Try this: =IF(OR(AND(S2<=0.0417,D2="Imagerie Conventionnelle"), ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,420 points • 211 views
0 votes
1 answer

Open Workbook on new instance

It must function. You aren't opening the Workbook ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 289 views
0 votes
1 answer

VBA to create a dynamic rolling list of names

If I understand you correctly, a case. ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 282 views
0 votes
1 answer

Excel VBA code not running using F5 only F8

Change your code like this: Dim LastColumn As ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 370 views
0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

SourceFolder is an object that only understands ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 369 views
0 votes
1 answer

VBA Excel get data from Access database Error

Try this: Sub getdata() Const ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,010 points • 450 views
0 votes
1 answer

Issues with NULL in an added and custom column

Try this: Fonte = ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,010 points • 229 views
0 votes
1 answer

Add a correct format date in Excel file with Python openpyxl

Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,420 points • 2,078 views
0 votes
1 answer

Count number of equal values in two rows in Excel

 Use this formula: =SUM(--(A2:E2=$A$1:$E$1)) READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 341 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Try this: let columnNames= {"E ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,010 points • 1,460 views
0 votes
1 answer

Excel, unable to update count

Try this: • Formula used in cell J14 =COUNTIFS($F:$F,$I14,$H:$H,K$13) Fill Down ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 243 views
0 votes
1 answer

Reading Excel file Date/time Incorrectly

Use dateutil.parser. Example usage: import dateutil.parser as parser parser.parse("2021-04-04 00:00:00 1900-01-01 ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 366 views
0 votes
1 answer

How to find out how many rows and columns to read from an Excel file with PHPExcel?

Solution: $file_name = htmlentities($_POST['file_name']); $sheet_name = htmlentities($_POST['sheet_name']); $number_of_columns = htmlentities($_POST['number_of_columns']); $number_of_rows ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,420 points • 6,764 views
0 votes
1 answer

Is there a limit on an Excel worksheet's name length?

The file format would allow worksheet names ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,420 points • 4,260 views
0 votes
1 answer

How to merge the Two Columns with two different Tables without getting duplicates in either of the resulting columns

Assume your tables as named are read ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,010 points • 405 views
0 votes
1 answer

Way to run Excel macros from command line or batch file?

Solution Open the workbook and run the macro ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 63,420 points • 5,800 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

I'm an Excel VBA programmer that had ...READ MORE

Mar 26, 2023 in Others by narikkadan
 • 63,420 points • 132 views
0 votes
1 answer

Return value if scores contain value form min and Max column

So based on my comments above, here ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 345 views
0 votes
1 answer

How do I adjust the size of the pasted image in Outlook email?

Try this : Option Explicit '~~> Since we are ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,420 points • 841 views
0 votes
1 answer

IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 340 views
0 votes
1 answer

VBA Macro Iteration

Try this: Sub macro1() ' Macro1 Macro ' Dim ws As ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 331 views
0 votes
1 answer

How do I change the format of an excel workbook from 'General' to 'Text'

Only cells have a format for numbers. ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 198 views
0 votes
1 answer

Merging duplicate cells into a new column with VBA

The requirement to pull the first Open ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 186 views
0 votes
1 answer

Encrypting and securing sheets for users

First off, instead of using a formula ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 271 views
0 votes
1 answer

Excel Date separate with =DAY(), =MONTH() and =YEAR()

If it must be done inside of ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 298 views
0 votes
1 answer

Loop through files using "" instead of Dir

Upon reading the documentation @Dir function (Visual ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 294 views
0 votes
1 answer

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

Consider using a fixed template for the ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 256 views
0 votes
1 answer

Filter date with time

Try this: Sub FilterInicioDeTurnoDAY() Dim in_time ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,010 points • 291 views
0 votes
1 answer

Divide data and copy other cells in google sheets or excel

Try this : const Sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(`YourSheetName`) function dataHandler() ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 243 views
0 votes
1 answer

Use union with find

Using the Find Method With a Discontinued ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,010 points • 287 views
0 votes
1 answer

Copy data with filter applied using Excel VBA

Try this: Private Sub CommandButton1_Click() Dim ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,010 points • 271 views
0 votes
1 answer

GetObject(xxx).Application not working/recognizing open files

You can reference open Excel files in ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 63,420 points • 1,243 views
0 votes
1 answer

Microsoft Excel - slow to open

We used to have a bat file ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 160 views
0 votes
1 answer

Delete table rows if time in column is >07:45

add a formula in a hidden column ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,420 points • 168 views
0 votes
1 answer

Runtime Error when trying to Loop Worksheets

Copy To Multiple Worksheets A Quick Fix Option Explicit Sub ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,010 points • 194 views
0 votes
1 answer

VBA SharePoint macro

I believe you are attempting to open ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,010 points • 1,618 views
0 votes
1 answer

Why does WinHTTPRequest responseText return a different value to MsgBox than Debug.Print dynamic web pages

The Immediate pane has a built-in limit ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,420 points • 616 views
0 votes
1 answer

How do ask ChatGPT with API from Excel macros (vba)?

A few things that will help. Don't ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,010 points • 1,661 views
0 votes
1 answer

How to automatically get a specified range of data from Excel to XML in VBA

Range method works, always identify the sheet ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,420 points • 540 views
0 votes
1 answer

Load Animated gif in UIImageView IOS

Load GIF image Swift : ## Reference. #1 : ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,640 points • 7,716 views
0 votes
1 answer

How to sum time in Excel?

Assuming your data is located at [D12:D22] Try this ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,420 points • 7,428 views
0 votes
1 answer

VBA: Do While Loop does not want to looping

Try this: currentRow = 11 Do While originalSheet.Cells(currentRow, 1).Value ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,420 points • 365 views
0 votes
1 answer

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Confusion: You must declare the parameter as ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,420 points • 365 views
0 votes
1 answer

Highlight cells in an Excel column if the value can be found in an array

Try this: =COUNTIFS(B:E,$A1) READ MORE

Feb 24, 2023 in Others by narikkadan
 • 63,420 points • 885 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Add column, custom column with formula: = try ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 63,420 points • 1,765 views
0 votes
1 answer

My VBA Addin creates a custom ribbon tab, but should only be visible for intended workbooks

The RibRefresh sub's logic is overly convoluted ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,010 points • 895 views
0 votes
1 answer

Stop power query from loading to excel sheet

You can just delete the worksheets created ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,420 points • 3,833 views
0 votes
1 answer

VBA Comment Format

Let's say you're having trouble referencing every ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,420 points • 299 views
0 votes
1 answer

How to make an error flagging array in VBA and translate all array elements as a string message?

In my opinion, using an array in ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
 • 38,010 points • 340 views
0 votes
1 answer

Autofill Copy down up until next empty row- Excel VBA Macro

Row 1048576 will be returned by end(xldown) ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,420 points • 1,095 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.