Most voted questions in Others

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
 • 86,360 points • 772 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
 • 86,360 points • 936 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
 • 86,360 points • 959 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
 • 86,360 points • 709 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
 • 86,360 points • 635 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
 • 86,360 points • 769 views
0 votes
1 answer

VBA - Dynamic Variable Name in a Loop

Set the array values with: Dim i as ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 2,342 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,000 points • 813 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,000 points • 945 views
0 votes
1 answer

VBA - Msgbox inside a Loop

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

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 977 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,000 points • 772 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,000 points • 983 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,000 points • 702 views
0 votes
1 answer

How to read an Excel CSV file in Python?

The csv module or the pandas library ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,119 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,000 points • 787 views
0 votes
0 answers

Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V

While initializing derby with bin/schematool -initSchema -dbType derby it ...READ MORE

Mar 14, 2023 in Others by Prashant
edited Mar 5 • 133 views
0 votes
0 answers

HOW TO GET A SPECIFIC CELL TO CHOOSE BETWEEN 5 FIXED CELLS BASED ON 01 VARIABLE CELL?

C3 gets a value from another Tab ...READ MORE

Mar 3, 2023 in Others by Sean
edited Mar 5 • 141 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
 • 86,360 points • 1,887 views
0 votes
0 answers

Input Box Date Validation

I have an update form for my ...READ MORE

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 665 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
 • 86,360 points • 918 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
 • 86,360 points • 1,095 views
0 votes
1 answer

How to read excel file column by column

Rows will provide you the rows, as ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 554 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
 • 86,360 points • 1,212 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
 • 86,360 points • 1,303 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
 • 86,360 points • 1,141 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 769 views
0 votes
1 answer

EXCEL - Is there a formula for TEXTSPLIT from 3 different rows into a sequencing of rows without data /text duplication?

SORT a UNIQUE TEXTSPLIT To Column Simple Be aware ...READ MORE

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

Dragging Down Skipping Rows

Try this: IF(IFERROR(MATCH(ROW(),$C$4:$C$12,0),0)>0,INDIRECT("M"&4+IFERROR(IF(ROW()=4,0,MATCH(ROW(),$C$4:$C$12,0)-1),0)),"") You can also use the help ...READ MORE

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

How to calculate current streak of conditional number, and excluding blanks?

To solve this  use xmatch if it's ...READ MORE

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

How can I sum all the data in January example

Your error is because your formula is ...READ MORE

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

Cross sum from a number but cross sum should total to one digit

Try this: Option Explicit Sub Quersumme_OneDigit() ...READ MORE

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

Reference Excel sheet number in an external workbook

Try this: Function SheetByCodeName(wb As Workbook, cn As ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
 • 38,000 points • 778 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,000 points • 812 views
0 votes
1 answer

Reshaping/Deduping long data to wide in R

Using pivot_wider and rename library(dplyr) library(tidyr) repl <- c("1st_transaction" = "type_1", "2nd_transaction" = ...READ MORE

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

outputting a coloured excel file, python

If you already have an Excel workbook, ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
 • 38,000 points • 522 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
 • 86,360 points • 1,716 views
0 votes
1 answer

Releasing COM-Object not necessary?

This place has infamously poor Office COM ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 1,059 views
0 votes
1 answer

Populating table or range to listbox in userform to get the values of the columns inside the table or range in closed workbook

Because rs.RecordCount is of type LongLong, which ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 1,392 views
0 votes
1 answer

EXCEL: Count case sensitive criteria in one column if meets criteria in another column

You may try: The formula in B1: =MAP(A1:A12,LAMBDA(x,SUM(- ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 890 views
0 votes
1 answer

Moving oldest files first from source to destination

You have to change the following line: If ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 970 views
0 votes
1 answer

Excel Desktop - Office.context.document.settings.get() didn't working

You need to call the saveAsync method of the Office.Settings interface ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 752 views
0 votes
1 answer

Add column from another table using excel power query

Use a left outer join to combine ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 1,684 views
0 votes
1 answer

How do I reference the cell value within a formula string?

Try: =HYPERLINK("#"&CELL("address",D116),B37) READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 1,533 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
 • 86,360 points • 1,757 views
0 votes
1 answer

VBA runtime error 1004 when copy and pasting

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

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

How to calculate median of unsorted values

In vba code: Dim r As Range Dim result 'Set ...READ MORE

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

How to compare 2 cells with delimited items in each and output the difference in items?

The following function would do this for ...READ MORE

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

Finding the minimum values from different columns according to the criteria and multiplying by another column

We must use SUBTOTAL and OFFSET in ...READ MORE

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

Excel Count unique values beetween 2 columns

Try this : • Formula used in cell D3 =LET(x,UNIQUE( ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 848 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,000 points • 2,466 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.