Trending questions in Others

0 votes
1 answer

Finding duplicate values in 5 excel sheets and results to be moved in the sixt one

See this article: VBA duplicated values coloring. I ...READ MORE

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

Looking to create a conditional statement in excel

Try using a rule based on a ...READ MORE

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

How to arrange a string to display

It's a bad idea to use spaces ...READ MORE

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

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 1,463 views
0 votes
1 answer

Formula to count if a text is written in a cell

Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE

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

Automating production of graphs using VBA

You have to change: chrtname = Cells(i, 2).Value To: chrtname ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,279 views
0 votes
1 answer

How to split only one column to multiple rows while copying rest of the columns along the way?

Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE

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

Remove the Rupee symbol in Laravel

Although there are other approaches you may ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 2,011 views
0 votes
1 answer

Select a range in Excel based on the value of a cell

Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE

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

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE

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

Selecting a value of a table in Excel

Use this formula: =LET(step1,FILTER(A1:D6,A1:D1=B11), INDEX(D1:D6, ...READ MORE

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

How can I allow a user to change a cell in excel only under particular conditions?

Copy the next event code in the ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 904 views
0 votes
1 answer

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 900 views
0 votes
1 answer

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 898 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

Application.DisplayStatusBar = True Is cancelling your ...READ MORE

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

How can I add a wildcard to my if formula (that also contains an or condition)

3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE

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

SSIS Excel Connection Manager failed to Connect to the Source

It seems like the 32-bit version of ...READ MORE

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

Insert multiple columns to the right in sequential order

Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE

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

Laravel - Connection could not be established with host smtp.gmail.com [ #0]

While using the Laravel project directory, edit ...READ MORE

Feb 22, 2022 in Others by Aditya
 • 7,680 points • 15,666 views
0 votes
1 answer

Change Data Source Range for ALL Pivot Tables that are Using a Particular Named Range Within Excel via VBA

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

Jan 7, 2023 in Others by narikkadan
 • 86,360 points • 1,907 views
0 votes
1 answer

Excel - return a value only if a condition is met via VBA

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 86,360 points • 1,081 views
0 votes
1 answer

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 5,134 views
0 votes
0 answers

Calendar React JS

I have a homework to make a ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 5,380 points • 1,047 views
0 votes
1 answer

What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 895 views
0 votes
1 answer

How to return the last n number of values corresponding to a specific category?

Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...READ MORE

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

Excel function to dynamically SUM UP data based on matching rows and columns

Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE

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

Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 874 views
0 votes
1 answer

Excel links keep crashing

When the links in the master sheet ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 873 views
0 votes
1 answer

Excel - How do I make rows that contain row headers into two columns

You can use this formula: =LET(values,B1:E2, headers,MAP(values,LAMBDA(v,INDEX(A1:A2,ROW(v)))), HSTACK(TOCOL(headers),TOCOL(values))) Via MAP the row headers ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 86,360 points • 1,042 views
0 votes
1 answer

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

You can use a Select Case statement : Option Explicit Sub ...READ MORE

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

VBA code for dragging down contents of a cell

Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE

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

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

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

Is there an excel function to tell if a cell has a dependency?

I think there is no built-in function ...READ MORE

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

Turning a .xlsx into multiple PDFs

You just need to adjust the font ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 795 views
0 votes
1 answer

Excel Connect data points with line is DISABLED

By replicating the data series and substituting ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 2,293 views
0 votes
1 answer

How to gentrate Unique Id in ReactJs

You can use useId to create a ...READ MORE

Feb 8, 2023 in Others by Damonlang
 • 1,230 points • 663 views
0 votes
1 answer

VBA code to select only a table. I am getting a Run-time error '1004'; Method 'Range' of object'_Global' failed

No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 1,550 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

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

Project ID printed for every task on the API problem

Try this: def teste(id): listID = ...READ MORE

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

How can I replace the nth occurence using regex in VBA?

Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 1,540 views
0 votes
1 answer

I Get "object required" error when using getElementByID

As you see LoginID is the id of the ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,449 views
0 votes
1 answer

Find value in column where running total is equal to a certain percentage

VBA bubble sort - no changes to ...READ MORE

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

VBA reordering columns from different workbook or sheet

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

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

How to get the total of every monday to saturday or tuesday to sunday in a month dynamically

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

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

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

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

Apache POI Excel row color is only black and doesn't change

Use this: style.setFillPattern(CellStyle.SOLID_FOREGROUND); In combination with: style.setFillForegroundColor(IndexedColors.AQUA.getIndex()); Sets the background color ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 1,816 views
0 votes
1 answer

Copy the time to the next row of another column

Try this: Sub CopyCurrentTime() Dim currentRow As Integer currentRow = ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 776 views
0 votes
1 answer

Multiple columns of excel only shown as 1 column

Data is separated into CSV (Comma Separated ...READ MORE

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

2D rotation of an object along a custom axis

Use this: Option Explicit Type ObjLocData ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 720 views
0 votes
1 answer

Unable to download excel file from src/assets in development/qa/prod environment for angular application

Try this: this.HttpClient.get("./assets/sample.xlsx",{responseType: "blob"}).subscribe((res:any) => ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 4,166 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.