Trending questions in Others

0 votes
1 answer

Get instances of rows in excel for a particular group

You can use the COUNTIF function with ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 1,325 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
 • 5,380 points • 1,607 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 • 1,149 views
0 votes
1 answer

Python/Openpyxl: change cell A1 in all excel worksheets within a workbook to equal the name of the worksheet tab

You made a mistake when you used ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 4,612 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,617 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 • 1,442 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 • 1,474 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 • 1,388 views
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 86,360 points • 4,237 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 • 1,251 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 • 1,208 views
0 votes
1 answer

How to set formula in Excel with POI?

Microsoft Excel only stores en US formula ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 2,068 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 • 1,377 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 • 1,242 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 • 1,412 views
0 votes
1 answer

How to print the next row every time a function runs? (openpyxl)

Verify the indentation. I executed the sample ...READ MORE

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

Changing code to adjust number of charts on each powerpoint slide VBA

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

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

Unprotect an Excel file programmatically

Try this. It worked for me.  def Remove_password_xlsx(filename, ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 86,360 points • 3,556 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 • 1,176 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
 • 86,360 points • 1,259 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 • 1,044 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 • 1,227 views
0 votes
1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 4,962 views
0 votes
1 answer

xlsx package:Write excel file to a custom path

The issue is that when you send ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 86,360 points • 3,521 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 • 1,096 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 • 1,182 views
0 votes
1 answer

Excel 365 Formulas - How to save LAMBDA function permanently (for all existing and new files)?

Try creating a template for excel to ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 86,360 points • 2,431 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
 • 86,360 points • 1,390 views
0 votes
1 answer

How to convert an XML file to an Excel file?

Create a CSV file that is in ...READ MORE

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

Excel number format: scale number by ten thousand or hundred thousand

In the MSExcel spreadsheet, Right Click on ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 5,830 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Before looping through all of the cells ...READ MORE

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

Reading Excel file using node.js

Several distinct libraries perform Excel file parsing ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 3,756 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

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

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE

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

PMT function in Javascript

Try the following settings to better understand ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 3,380 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 4,195 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 1,632 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 • 1,023 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 • 1,278 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,418 views
0 votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

Check the .Row first: With Sheets("Line 3").Range("G1024").End(xlUp) ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 2,032 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
 • 86,360 points • 1,255 views
0 votes
1 answer

Conditional Formating in Excel comparing dates between cells

To get a date from your strings, ...READ MORE

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

Public variable for captura path in vba excel

An assignment statement (as ruta = ActiveWorkbook) ...READ MORE

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

white screen on simulator iphone Xcode

After creating the request, you must actually ...READ MORE

Sep 20, 2022 in Others by Aditya
 • 7,680 points • 6,944 views
0 votes
1 answer

Microsoft Open XML Read Excel file using SAX method row by row and finding cell data

I faced a comparable challenge. A bespoke ...READ MORE

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

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

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

Open SAP from Excel VBA

It just means that there is no ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 6,520 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.