Trending questions in Others

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 • 2,066 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 • 1,068 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 • 1,003 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,496 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,155 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 • 2,033 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
 • 86,360 points • 773 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,000 points • 926 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
 • 86,360 points • 932 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 • 925 views
0 votes
1 answer

Django upload and process multiple files failing with libreoffice

The problem happens when LibreOffice tries to ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,119 views
0 votes
1 answer

How to scrape the specific text from kworb and extract it as an excel file?

The best practice to scrape tables is ...READ MORE

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

Excel formatting: show percent value without percent sign

You can change how it appears while ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 86,360 points • 4,997 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 • 1,369 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,909 views
0 votes
1 answer

Create numbered XML nodes, set attributes when creating XML node

Just like createElement, createAttribute is a method of the xml ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,064 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 • 1,353 views
0 votes
1 answer

Converting excel to pdf using PHP

If utilizing PHP on a Windows PC, ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 86,360 points • 7,162 views
0 votes
1 answer

How to increment the Range of a For Each loop - Excel VBA

Your formula seems to sum 1 single ...READ MORE

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

Export DataFrame timedelta column to timestamp Excel column

The reason that the column format isn't ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,550 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,748 views
0 votes
1 answer

Filter outlook sent items in vba failing for emails with multiple recipients

The PR DISPLAY TO parameter provides a ...READ MORE

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

Excel VBA: Obtain the Column and Row of current element in "For Each" loop

Try this: MsgBox rng.Address(RowAbsolute:=False, ColumnAbsolute:=F ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 2,157 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 • 40,451 views
0 votes
1 answer

VBA Excel: Draw line between cells based on cell value

In accordance with your description and with ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,479 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 • 1,196 views
0 votes
1 answer

Modifying Excel document using python and openpyxl

The style will be set to Hyperlink ...READ MORE

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

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 86,360 points • 8,429 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 • 1,179 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 • 1,162 views
0 votes
1 answer

VBA Copy/Paste a Range in Next Available Column Then Add a Single Day to One of the Newly Pasted Cells Repeatedly

With a date you can treat it ...READ MORE

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

The delete method of the range class failed in vba

Delete Criteria Rows Efficiently Sub DeleteCriteriaRows() ...READ MORE

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

EXCEL Userform - Creating multiple Labels and Textboxes with specific names

Please, test the next scenario: Insert a class ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 86,360 points • 2,281 views
0 votes
1 answer

How to paste an Excel chart into PowerPoint placeholder using Python?

Very near indeed! Copy and Paste are ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 7,681 views
0 votes
1 answer

How to Convert nested JSON into excel in nodejs

Try this: const filtered = attendanceData.map(obj => { ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 4,121 views
0 votes
1 answer

Excel VBA: how to find a description from an AD-group

First add the 'description' property to your ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 1,918 views
0 votes
0 answers

runs on f8 but not on f5

Sub copypartdatatest()     Dim ctr, tdt, lr, lr1, lr2, ...READ MORE

Mar 25, 2023 in Others by Madhusudan
edited Mar 5, 2025 • 355 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 • 1,098 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 • 3,076 views
0 votes
1 answer

Excel formula exceeds 8000 characters limit

Using auxiliary columns to divide the formula ...READ MORE

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

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 3,573 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 • 1,047 views
0 votes
1 answer

CodeIgniter: Unable to connect to your database server using the provided settings Error Message

 I'm assuming there is something wrong with ...READ MORE

Feb 16, 2022 in Others by Soham
 • 9,730 points • 17,626 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 • 1,025 views
0 votes
1 answer

Color specific cell in an xlsx with python

Column B's cells must be iterated through ...READ MORE

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

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 2,061 views
0 votes
1 answer

How do I get text in a pivot table in excel or google sheets?

Try: =QUERY(QUERY({Data!A:A, Data!Q:S}, "select Col4,max(Col1) ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,257 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.