Most viewed questions in Others

0 votes
0 answers

iOS: Intercept certain numbers when dialed and start own app

Usecase: my hotline has phone number 0815/111222333 user ...READ MORE

Sep 23, 2022 in Others by gaurav
 • 23,260 points • 220 views
0 votes
0 answers

left join and left outer join?

What is the difference between LEFT JOIN ...READ MORE

Jun 7, 2022 in Others by polo
 • 1,480 points • 220 views
0 votes
1 answer

Click cell to generate dynamic table

Try the following: The formula in F1 (as per my ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 63,700 points • 219 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 • 218 views
0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 218 views
0 votes
0 answers

xcel VBA Chart counting and formatting

I want to develop a macro that ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,010 points • 218 views
0 votes
0 answers

Why is my console.log(persons.includes(newNameObject)) returning as false, when newNameObject already exists in the array?

I am working on a simple react ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 3,820 points • 217 views
0 votes
1 answer

Excel how to fill all selected blank cells with text

Do the following to place the same ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,700 points • 217 views
0 votes
0 answers

Simplest code for array intersection in javascript

Tell me the simplest way to implement ...READ MORE

Aug 12, 2022 in Others by krishna
 • 2,820 points • 217 views
0 votes
0 answers

Importing Excel files into R, xlsx or xls

Please can someone help me on the ...READ MORE

Jun 13, 2022 in Others by Avinash
 • 1,260 points • 217 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 • 217 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,700 points • 216 views
0 votes
0 answers

Excel: Remove Duplicates based on time condition

A 3 month rolling time condition is ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,010 points • 216 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 • 215 views
0 votes
1 answer

Count the sum of difference between two cells

Use a for loop: Sub AbsoluteDifference() ...READ MORE

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

How do I find top row visible on Sheet in Excel

Try this: ? Activewindow.VisibleRange.Row READ MORE

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

Macro that deletes all asterisk signs from cells

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

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

Random #NAME error only while running macro

For those who are wondering what happened ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,700 points • 214 views
0 votes
0 answers

Differentiate between function overloading and function overriding

May 15, 2022 in Others by Kichu
 • 19,050 points • 214 views
0 votes
0 answers

DynamoDB time to live per Item

I have a requirement to expire items ...READ MORE

Apr 5, 2022 in Others by Kichu
 • 19,050 points • 214 views
0 votes
1 answer

Adjacent excel cells show same cell address on using =cell("address") formula.

Use the reference argument: =CELL("address",L54) From the docs: reference: The cell that you ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,010 points • 213 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,010 points • 212 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 • 212 views
0 votes
1 answer

Why is a Variant parameter changing its type on function call

Remove parentheses If SaveSettings Then SaveFormSettings FormReferen This will ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,700 points • 211 views
0 votes
0 answers

SQL Group By with an Order By

I have a table of tags and ...READ MORE

Jun 22, 2022 in Others by nisha
 • 2,210 points • 211 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
 • 63,700 points • 210 views
0 votes
1 answer

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Use  SHFileOperation API Option Explicit Private Declare PtrSafe Function SHFileOperation ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,010 points • 210 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 • 210 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,010 points • 209 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
 • 63,700 points • 209 views
0 votes
1 answer

Excel, AVERAGEIFS, Date discrepancy

When defining a range, you are unable ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,700 points • 209 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 • 208 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
 • 63,700 points • 208 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
 • 63,700 points • 207 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
 • 63,700 points • 206 views
0 votes
0 answers

What do Clustered and Non-Clustered index actually mean?

 I want to know about Clustered and Non clustered indexes. ...READ MORE

Jun 22, 2022 in Others by nisha
 • 2,210 points • 206 views
0 votes
0 answers

Excel 2010, how to keyboard shortcut to filter dropdown checkboxes?

how do I get to the filter ...READ MORE

Feb 10, 2022 in Others by Edureka
 • 13,670 points • 206 views
0 votes
0 answers

What is automation in computer?

What is automation in computer? READ MORE

Feb 2 in Others by Hoor
 • 540 points • 205 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
 • 63,700 points • 205 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
 • 63,700 points • 205 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
 • 63,700 points • 203 views
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,010 points • 202 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 • 202 views
0 votes
0 answers

get unique distinct items based on a condition and a date condition

hi could you help me sorry my ...READ MORE

Nov 23, 2021 in Others by adolpo
 • 120 points • 202 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 • 201 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
 • 63,700 points • 200 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
 • 63,700 points • 200 views
0 votes
0 answers

Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,010 points • 200 views
0 votes
1 answer

Ordering data in python or excel

Basically, the data is converted from wide ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,010 points • 199 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 • 198 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.