Trending questions in Others

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
 • 63,700 points • 270 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
 • 63,700 points • 224 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
 • 63,700 points • 218 views
0 votes
0 answers

React useEffect Hooks with setTimeout

I am so confused here with React ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 3,820 points • 629 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
 • 63,700 points • 302 views
0 votes
1 answer

What VBA Code to Hide Excel Quick Access Toolbar?

Use this: Sub HideQuickAccessTB() Application.ExecuteExcel4Macro ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,700 points • 777 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
 • 63,700 points • 256 views
0 votes
1 answer

Compare each excel sheets with a table in oracle

One way to verify the count and ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 63,700 points • 206 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
 • 63,700 points • 461 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
 • 63,700 points • 497 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
 • 63,700 points • 397 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

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

Jan 24, 2023 in Others by narikkadan
 • 63,700 points • 691 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
 • 63,700 points • 385 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
 • 63,700 points • 403 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
 • 63,700 points • 357 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
 • 63,700 points • 220 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
 • 63,700 points • 263 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
 • 63,700 points • 351 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,700 points • 1,041 views
0 votes
1 answer

How to remove data within a multi-line cell that comes after a few line breaks

find() return the starting position of a ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 63,700 points • 565 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
 • 63,700 points • 772 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
 • 63,700 points • 206 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
 • 63,700 points • 543 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 • 218 views
0 votes
1 answer

Divide a range of values for each unique value

With the next available row as the ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,700 points • 232 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
 • 63,700 points • 356 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
 • 63,700 points • 351 views
0 votes
1 answer

Excel formula to calculate MIN in table filtered

Try this: =SUBTOTAL(105;B2:B7) READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,700 points • 342 views
0 votes
1 answer

Want to create a chronological row # then reset based on font color

Use this function to test the font ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,700 points • 206 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
 • 63,700 points • 377 views
0 votes
1 answer

How to show a row in excel if there is a X

FILTER Function: "filters" a range of data ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,700 points • 202 views
0 votes
1 answer

Extracting info from hyperlink

This will offer you an example of ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,700 points • 191 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
 • 63,700 points • 487 views
0 votes
1 answer

Export ListBox Data to Sheet range

Use ListCount to retrieve the number of ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 1,091 views
0 votes
0 answers

Calendar React JS

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

Jan 27, 2023 in Others by Tejashwini
 • 3,820 points • 461 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
 • 63,700 points • 337 views
0 votes
1 answer

How do I show the computations after S/N 1048576 in a separate sheet

Add: If xRg.Row = xRg.Parent.Rows.Count Then ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 63,700 points • 245 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
 • 63,700 points • 232 views
0 votes
1 answer

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,700 points • 2,212 views
0 votes
1 answer

Excel file download using java - Error : File is corrupted

Try this: @GetMapping("/downloadDOA") public ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,700 points • 1,686 views
0 votes
1 answer

How to link two excel sheet in same excel file

It would be best if you made ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,700 points • 299 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
 • 63,700 points • 638 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
 • 63,700 points • 708 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,700 points • 1,878 views
0 votes
1 answer

Can not get bubble sort to run in excel's developer mode

Bubble Sort a Single-Column Range A Quick Fix Option ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,700 points • 231 views
0 votes
1 answer

Sum the total of a column in excel and paste the sum to a different workbook

Get Column Sum From Closed Workbook Option Explicit Sub ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 63,700 points • 395 views
0 votes
1 answer

Pivoting 4x4 into 16x1

Try this: df <- tibble::tribble( ~ID, ~sit1, ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,700 points • 220 views
0 votes
1 answer

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

 The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,700 points • 261 views
0 votes
1 answer

VBA How To Paste With Blank One Column Over?

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

Jan 26, 2023 in Others by narikkadan
 • 63,700 points • 387 views
0 votes
1 answer

Iterate thru specific controls in a form using a loop

The textbox numbers you want to iterate ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,700 points • 248 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.