Trending questions in Others

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,159 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
 • 86,360 points • 1,282 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
 • 86,360 points • 2,917 views
0 votes
1 answer

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Average Every Nth Row All three finish in ...READ MORE

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

How to create a dependent drop down list using [Apache POI]

There is nothing apache poi cannot do, ...READ MORE

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

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 4,458 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,000 points • 1,216 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,071 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,200 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 • 2,088 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,408 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,096 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,130 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,385 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,038 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,316 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,187 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,260 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,298 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,373 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,231 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,098 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,137 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,295 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 • 5,591 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,074 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 • 18,628 views
0 votes
1 answer

xlsxwriter formatting is corrupting my excel file

The problem is that while attempting to ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 4,784 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
 • 86,360 points • 1,107 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,716 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 • 2,967 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,691 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,689 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 • 2,270 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,053 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,218 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,212 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 • 1,154 views
0 votes
1 answer

Change sheet tab color depending on CountA function result

Try using the ws. prefix to set ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 803 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,143 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 • 4,404 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
 • 86,360 points • 893 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,000 points • 1,067 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 • 2,401 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,142 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 • 1,138 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 • 2,293 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
 • 86,360 points • 933 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
 • 86,360 points • 1,032 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.