Most viewed questions in Others

0 votes
1 answer

Need help to delete rows in VBA

Here is a basic macro that deletes ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 631 views
0 votes
0 answers

Date time convert in Replace activity in word document scope

we have input in excel  New date/Header 31/12/2020 31/12/2019 We  want ...READ MORE

Jun 22, 2020 in Others by Sapna
 • 120 points
recategorized Jun 22, 2020 by Gitika • 630 views
0 votes
1 answer

what is azure?

Azure is a cloud computing platform and ...READ MORE

Jun 21, 2023 in Others by Khan Sarfaraz
• 700 points • 629 views
0 votes
1 answer

Chart Name in Excel 2016

When you select the chart, it's now ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 86,360 points • 628 views
0 votes
1 answer

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

I think this might be more of ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 627 views
0 votes
1 answer

User form to print an array of sheets

It appears that when a UserForm is ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 623 views
0 votes
0 answers

Shortcut to insert row in excel

What is the Excel shortcut for inserting ...READ MORE

Sep 7, 2023 in Others by anonymous
 • 990 points • 621 views
0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 619 views
0 votes
0 answers

pure component in react

What is a pure component in React ...READ MORE

Nov 6, 2023 in Others by Arya
 • 990 points • 616 views
0 votes
1 answer

Division formula in excel

You may use this Array formula in ...READ MORE

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

Understanding How Excel Processes Array Functions

An array formula is a formula that can ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 615 views
0 votes
0 answers

In 2019, AtoX leads the new trend of decentralized exchanges

Under the influence of the blockchain continuing ...READ MORE

Jan 29, 2019 in Others by anonymous
 • 615 views
0 votes
0 answers

How can I sort arrays and data in PHP?

These are my primary questions: How do I ...READ MORE

Aug 8, 2022 in Others by krishna
 • 2,820 points • 613 views
0 votes
0 answers

What does the suspend function mean in a Kotlin Coroutine?

I'm reading Kotlin Coroutine and know that ...READ MORE

May 26, 2022 in Others by Harshitha
 • 120 points • 612 views
0 votes
0 answers

How to use VIF in r?

1 I'm new to R and using caret ...READ MORE

Jun 13, 2022 in Others by Avinash
 • 1,260 points • 611 views
0 votes
1 answer

Divide data and copy other cells in google sheets or excel

Try this : const Sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(`YourSheetName`) function dataHandler() ...READ MORE

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

Generate number by using Dynamic array (w/o VBA)

Try: The formula in F2: =IFERROR(REDUCE(HSTACK("Name",SEQUENCE(,MAX(D2#))),UNIQUE(A2#),LAMBDA(a,b,LET(c,BYROW(HSTACK(C2#,D2#),LAMBDA(d,MIN(d))),e,FILTER(HSTACK(B2#,B2#&"-"&c,D2#),A2#=b),VSTACK(a,HSTACK(b,XLOOKUP(SEQUENCE(,MAX(DROP(e,,2)))-1,TAKE(e,,1),INDEX(e,,2),0,1)))))),"") If you really happen to ...READ MORE

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

Excel remaining days count from today until due date minus weekends?

The problem is that you are not ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 609 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 • 608 views
0 votes
1 answer

Choosing a random text value from a list

Try this: =CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1, ...READ MORE

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

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 602 views
0 votes
0 answers

Excel formula converting tan to angle

I have an excel spreadsheet that computes ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 602 views
0 votes
0 answers

what is artificial intelligence

Dec 20, 2021 in Others by Edureka
 • 13,680 points • 602 views
0 votes
1 answer

Sublist on Excel

Try using this formula in sheet 1  =FILTER(Sheet2!B3:B8,Sheet2!E3:E8<2) The ...READ MORE

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

Excel Power Query Moves old Data to the right

Just empty the page and then add ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 601 views
0 votes
0 answers

Combining MID and LEFT Functions in Excel 2019

I currently have a course name and ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
 • 38,000 points • 601 views
0 votes
1 answer

Avoiding index & match #N/A value

Use IFERROR to set an alternative value if the ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 600 views
0 votes
1 answer

Weird Date change when copying a Worksheet into a new workbook

Try  this: Dim wb ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 599 views
0 votes
0 answers

What is the difference between a deep copy and a shallow copy?

May 9, 2022 in Others by Kichu
 • 19,040 points • 599 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

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

seo component gatsby- effecting layout

<link ...READ MORE

Feb 20, 2022 in Others by narikkadan
 • 86,360 points • 598 views
0 votes
0 answers

I am getting this data from my server

May 29, 2019 in Others by anonymous
 • 595 views
0 votes
1 answer

Excel - IFERROR Function

Use: =IF(ISNUMBER(FIND("Bob",A2)),"Other",A2) Remember FIND is an exact match while SEARCH does not care ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 86,360 points • 591 views
0 votes
0 answers

Android does not provide any two step toggle button?

I look into some of the android ...READ MORE

Jun 7, 2022 in Others by polo
 • 1,480 points • 591 views
0 votes
0 answers

Differentiate between function overloading and function overriding

May 15, 2022 in Others by Kichu
 • 19,040 points • 587 views
0 votes
0 answers

SEO META Tags - HTML

i have registered my sited with google ...READ MORE

Feb 14, 2022 in Others by Kichu
 • 19,040 points • 587 views
0 votes
0 answers

Creating a chart in Excel that ignores #N/A or blank cells

A dynamic data series will be used ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 586 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 • 582 views
0 votes
0 answers

Two Backslash in SQL procedure with regular expression

On SQL procedure where i saw a Regular ...READ MORE

May 26, 2022 in Others by polo
 • 1,480 points • 580 views
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 • 578 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 • 577 views
0 votes
0 answers

Formula in Excel with a particular increment value

I need to use Excel formulas for ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 575 views
0 votes
1 answer

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 575 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Try this: =QUERY(QUERY({QUERY('Movimentações'!A2:J,"Select F,C,D,E,(I*-1),(I*-1*J),(I*0),(J*0) where A matches 'Venda' ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 574 views
0 votes
1 answer

Exclude worksheets from loop with a list

You can achieve this by making a ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 573 views
0 votes
0 answers

Search.SafeFinder.com Homepage Removal

Can anyone recommend me how can I ...READ MORE

Nov 23, 2020 in Others by john
 • 140 points • 572 views
0 votes
0 answers

Write a DAX query to obtain the bottom 5 customers based on the order price

Jan 22, 2020 in Others by anonymous
 • 170 points • 572 views
0 votes
0 answers

How does a tool like SEOMoz Rank Checker work?

i am planning to implant a feature ...READ MORE

Feb 14, 2022 in Others by Kichu
 • 19,040 points • 570 views
0 votes
1 answer

Multiple Select Case Statements in a Single Procedure

Here's a slightly different structuring that will ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 569 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.