Trending questions in Others

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,600 points • 1,390 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,600 points • 2,279 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,600 points • 831 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,000 points • 1,412 views
0 votes
1 answer

Close One Tab within Chrome via VBA

Sod's law worked it out within a ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 1,963 views
0 votes
1 answer

Return empty cell from formula in Excel

There is no way to do this ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,600 points • 5,496 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,600 points • 745 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,600 points • 1,537 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
 • 63,600 points • 1,240 views
0 votes
1 answer

Getting SUM for hh:mm:ss in EXCEL

The times are probably preserved as text. SUM ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,600 points • 6,592 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,600 points • 683 views
0 votes
1 answer

Export All appointments and meetings (including recurring meetings) Excel VBA

However, when I use the code above ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 1,688 views
0 votes
1 answer

TODAY() function not working in Microsoft Excel

Works as shown: Just note that cell c1 ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,355 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
 • 63,600 points • 4,430 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
 • 63,600 points • 1,860 views
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

You can break out the "copy column ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 63,600 points • 2,368 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,600 points • 542 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 • 1,100 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,097 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
 • 63,600 points • 1,047 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 • 1,199 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 • 524 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
 • 63,600 points • 478 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
 • 63,600 points • 1,004 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 • 489 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 • 484 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 • 1,142 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 • 465 views
0 votes
1 answer

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,600 points • 2,886 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 • 404 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
 • 63,600 points • 358 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 • 387 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 • 386 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
 • 63,600 points • 1,011 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 • 359 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 • 1,268 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 7,107 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 • 301 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
 • 63,600 points • 1,570 views
0 votes
0 answers

Laravel Minio Temporary URL

I'm looking for a hacky way to ...READ MORE

Feb 14, 2023 in Others by Ashwini
 • 5,430 points • 1,232 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
 • 63,600 points • 2,572 views
0 votes
1 answer

After exporting ssrs report excel name should have todays date

If you use URL Access to generate the report, ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,600 points • 1,366 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,025 views
0 votes
1 answer

Get column index from table header in excel

Try it. The StaffDetailsTbl table's headers are ...READ MORE

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

How to copy entire data using row by row and paste to another sheet

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

Feb 5, 2023 in Others by narikkadan
 • 63,600 points • 1,520 views
0 votes
1 answer

Confused on VBA copy destination

Try this: Sub so75496418AddChart() Dim rng As Range Dim strTypeName ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 872 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
 • 63,600 points • 1,466 views
0 votes
1 answer

Excel VBA select range

Please test the following event with adapted ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 999 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
 • 63,600 points • 813 views
0 votes
1 answer

VLOOKUP to find weeknumber

Use  ISOWEEKNUM with the dates of the ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 994 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.