Trending questions in Others

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,000 points • 1,723 views
0 votes
1 answer

Count unique matches between two rows in Excel

The formula should be (in Excel 365) =SUM(--(COUNTIF(Draws!$B$2:$G$18,B2:K2)>0)) so ...READ MORE

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

Excel - How do I round a date type to the next hour if it is more than one minute

Add almost 30 minutes and it'll get ...READ MORE

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

Excel Pivot Table : Calculated Field ( formula to be used like sumproduct)

With a calculated field, you might not ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 5,154 views
0 votes
1 answer

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,306 views
0 votes
1 answer

How to solve "Error: Apache shutdown unexpectedly"?

To answer your question, as this port ...READ MORE

Feb 10, 2022 in Others by Rahul
 • 9,690 points • 19,251 views
0 votes
1 answer

Processing in vba

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

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,341 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,000 points • 1,598 views
0 votes
1 answer

Macro throwing error when run from customized ribbon

The original macro was created in an ...READ MORE

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

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 6,190 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
 • 86,360 points • 1,709 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 • 1,881 views
0 votes
1 answer

Writing large Excel in Java causing high CPU usage using apache-poi

Giving SXSSFWorkbook a window size appears to ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 86,360 points • 3,987 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Try this: =QUERY(QUERY({QUERY('Movimentações'!A2:J,"Select F,C,D,E,(I*-1),(I*-1*J),(I*0),(J*0) where A matches 'Venda' ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,310 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 • 1,817 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,000 points • 1,647 views
0 votes
1 answer

iCell.Value takes too long

Please try the following modified code. The ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,476 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,000 points • 1,644 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 • 1,856 views
0 votes
1 answer

VBA - Insert Spilt Cell Value

Your desired outcome will not be produced ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,286 views
0 votes
1 answer

Look at first empty row after the first few rows of my excel are empty, but the rest are populated

Concatenate If Not Blank Replace the J with I to replace as ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,365 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
 • 86,360 points • 1,580 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
 • 86,360 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
 • 86,360 points • 2,287 views
0 votes
1 answer

Excel VBA compare values on multiple rows and execute additional code

I would use a Dictionary & Collection ...READ MORE

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

Highlight duplicates with only 2 colors

Try this: Sub ColorCompanyDuplicates2() 'best practice to define all ...READ MORE

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

List Fridays and Saturdays in excel

 Try this: =TEXT(FILTER(SEQUENCE(DAY(EOMONTH(A4,0)),,EOMONTH( ...READ MORE

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

How do I build a loop into this TimeStamp VBA Code?

As Target is a range, it may ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,425 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,000 points • 1,504 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,000 points • 1,715 views
0 votes
1 answer

See cell content instead of formula in formulabox in Excel using VBA

A VBA Lookup: Lookup Headers in an ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,448 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 • 1,788 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 • 1,783 views
0 votes
1 answer

Excel Script keeps giving error "Range merge: You cannot perform the requested operation."

Range.merge() Operation is not possible in ExcelScript ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 2,820 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 • 2,223 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
 • 86,360 points • 1,590 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 • 1,712 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 • 2,205 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
 • 86,360 points • 1,489 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 • 2,700 views
0 votes
1 answer

How to clear TextField Entered Text automatically in Flutter?

Hi@akhtar, You can control the TextField in your ...READ MORE

Sep 10, 2020 in Others by MD
 • 95,460 points • 41,411 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 4,464 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,000 points • 1,429 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
 • 86,360 points • 1,469 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 86,360 points • 4,141 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 • 1,633 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
 • 86,360 points • 1,586 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.