Most answered questions in Others

0 votes
1 answer

How to create arrow buttons in Excel to scroll the table left and right?

Ctrl-shift-home goes to the upper-left of all ...READ MORE

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

How can I set a number for a public variable at userforms in excel?

Try: Public b As Integer Private Sub exa_Click() b = ...READ MORE

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

Loop through each cell in a given range and change the value depending on value in a column in the same row

Use match() and if() without code at ...READ MORE

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

ActiveSheet.Hyperlinks.Add don't show Text To Display

Here's how Excel functions. Not a bug, ...READ MORE

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

Combine Two Formulas in Separate Cells Into One Cell

Use the openpyxl module in Python to do that, ...READ MORE

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

Extracting a Variable Number of Letters from a Formula using VBA Code

Please, try the next function: Function extractLetter(rng As ...READ MORE

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

How to assign assign condition using if statement and VLOOKUP?

You can use either XLOOKUP() or INDEX() with MATCH() Function. • Formula used in ...READ MORE

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

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,010 points • 465 views
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

TextEffect to TextFrame Adjustment (Mismatch)

Delete the original shape and then replace, ...READ MORE

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

Python: How do I get multiple results in the same excel sheet?

Try this: fmin = lambda x: abs(x).min() fmax = ...READ MORE

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

Run time error 3343 unrecognized database format

Try using ADODB. Option Explicit Sub Export1line() ...READ MORE

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

Is there a way to produce a sum according to date/time stamp values of another column on excel?

Assuming the input data for the second ...READ MORE

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

For a cell that is consistent across ...READ MORE

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

VBA & Ascii Art

This is possible with a two-dimensional array. ...READ MORE

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

VBA Macro to add a relative reference column

You may accomplish this using an Excel ...READ MORE

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

How do I stop python from appending data to the same row in excel?

There is no indication in your code ...READ MORE

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

VBA - Build a Two-Column Array By Looping Through one Array with a Specific Criteria and Selecting From Another Array

As already mentioned as comment: Loop over ...READ MORE

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

VBA Regular Expression to return ALL matching patterns

You have set the global to false, ...READ MORE

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

Macro VBA code failing to execute a section of the code without an error

You get your code to make a ...READ MORE

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

Open Existing PowerPoint via VBA

You do not have the proper reference ...READ MORE

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

VBA how to calculate depth of items in excel, simliar to a BOM system

Add on the sheet an ActiveX Microsoft ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,010 points • 320 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

Why does difference between same dates shows a difference of 1 month in Excel?

That's because you formatted the output using ...READ MORE

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

Export multiple worksheets without formula with the ability to select exact sheets and location

Try this: Sub ExportSheets() Dim ...READ MORE

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

How to detect value in change in excel using python?

You might keep a txt file with ...READ MORE

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

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,010 points • 293 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 • 290 views
0 votes
1 answer

VBA - Build an Array by Looping Through Another Array with Specific Criteria

Please attempt the next option. It is ...READ MORE

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

Substring/Find last occurence of "/" and output everything to the right of it

Use TEXTAFTER() Function: =TEXTAFTER(B2,"/",-1) READ MORE

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

How to programmatically get the values of a spilled Excel range in VBA?

By using the Text property, I was ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 720 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 • 284 views
0 votes
1 answer

VBA Loop to select then copy a range of cells based on value in column B

Try this: Sub Macro2() Dim ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,420 points • 1,705 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 • 187 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

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Range(...) instructs VBA to always use the ...READ MORE

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

How to read a txt with pandas, and correctly put it in a dataframe to be converted to excel

It appears that you wish to create ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 1,345 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 • 273 views
0 votes
1 answer

Why does this VBA Macro that copies and paste range into email in the wrong order?

When a message body is created by ...READ MORE

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

Excel VBA Selecting Multiple columns with last row and apply Condition Format

Try this: Sub Test() Dim ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 691 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

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 • 371 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 • 370 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 • 161 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 • 367 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 • 346 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

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