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
 • 63,700 points • 264 views
0 votes
1 answer

Adding a percentage sign to a number field in Excel

Format these cells with custom format ?\% READ MORE

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

Querying for the second largest salary

general SQL query should be as follows: select ...READ MORE

Jun 16, 2022 in Others by polo
 • 1,480 points • 264 views
0 votes
1 answer

How to add if this cell = 0 skip and go next

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

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

Is W3C validation important?

try using use W3C conventions as much ...READ MORE

Feb 26, 2022 in Others by narikkadan
 • 63,700 points • 262 views
0 votes
1 answer

Prevent a user from adding or removing row(s) of a Range, but allow him to do so on another Range on the same sheet

The only thing I can offer is ...READ MORE

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

A value which should be judged by a scale gets bad judgement sometimes

Only the period (.) is accepted by ...READ MORE

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

Drawing an excellent cow

If you are on Linux and have cowsay installed ...READ MORE

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

How to use relative names in Excel VBA

It appears you are looking for Range.Offset() http://msdn.microsoft.com/en-us/library/office/ff840060%28v=office.15%29.aspx However, you ...READ MORE

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

A button in excel sheet does not work for the first time

When you press the Display button, the ...READ MORE

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

How to validate values entered in a multiline Excel cell?

Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE

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

Add user-defined function (UDF) to built-in category in Excel

Use Application.MacroOptions This example adds a user-defined macro ...READ MORE

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

Is Addon domain affecting SEO

search engines wont automatically link your addon-domain ...READ MORE

Feb 17, 2022 in Others by narikkadan
 • 63,700 points • 259 views
0 votes
1 answer

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Average Every Nth Row All three finish in ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,700 points • 258 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,050 points • 258 views
0 votes
1 answer

EXCEL - Is there a formula for TEXTSPLIT from 3 different rows into a sequencing of rows without data /text duplication?

SORT a UNIQUE TEXTSPLIT To Column Simple Be aware ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
 • 38,010 points • 257 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

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

Check whether a cell contains a substring

Try using this: =ISNUMBER(SEARCH("Some Text", A3)) This will return TRUE if ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 63,700 points • 257 views
0 votes
0 answers

How do I determine the size of my array in C?

How do I determine the size of ...READ MORE

May 1, 2022 in Others by Kichu
 • 19,050 points • 257 views
0 votes
1 answer

Document changes in a graph excel

To be able to trace changes, the ...READ MORE

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

Using Substitute or Replace to change specified characters to characters in another cell in a specific order Excel

Replace Occurrences of a Substring With a ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 63,700 points • 255 views
0 votes
1 answer

How can find location of value in a square using excel

For the cell address: =LET(ζ,B4:F11,BASE(MIN(IF(ζ=M ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 255 views
0 votes
0 answers

Deleting an element from an array in PHP

Is there a method to delete an ...READ MORE

Aug 12, 2022 in Others by krishna
 • 2,820 points • 255 views
0 votes
1 answer

what is microsoft azure used for?

Microsoft Azure is used as a cloud ...READ MORE

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

Highlight duplicates with only 2 colors

Try this: Sub ColorCompanyDuplicates2() 'best practice to define all ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,700 points • 254 views
0 votes
0 answers

VBA Excel MID Function Array

In order to calculate a UPC Check ...READ MORE

Jan 24, 2023 in Others by Kithuzzz
 • 38,010 points • 254 views
0 votes
1 answer

Excel - Stack Data based in Condition

Try this : =TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss") It appears you tried Filter ...READ MORE

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

Share Facebook or Line with onclick function, but get SEO problem "Links are not crawlable"

actually you can go forward with ignoring ...READ MORE

Feb 17, 2022 in Others by narikkadan
 • 63,700 points • 253 views
0 votes
0 answers

Why does Excel give me a #NAME? error when I open this CSV file?

The CSV file consists of two lines: ...READ MORE

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

Look at first empty row after the first few rows of my excel are empty, but the rest are populated

Concatenate If Not Blank Replace the J with I to replace as ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,700 points • 252 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,010 points • 252 views
0 votes
0 answers

Point-In-TIme data restore on Amazon RDS

I hosted the MySQL database on amazon ...READ MORE

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

VBA Repeatable Function on button click

Remove Duplicates Based on a Single Column The ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 63,700 points • 251 views
0 votes
1 answer

Issues with NULL in an added and custom column

Try this: Fonte = ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,010 points • 251 views
0 votes
0 answers

locked textbox property set to true at worksheet

Hello, I have textboxes (activeX controls) on ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,010 points • 251 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,050 points • 251 views
0 votes
1 answer

Substring in excel

Hi Basically there is no specific formula ...READ MORE

Feb 16, 2022 in Others by Edureka
 • 13,670 points • 251 views
0 votes
1 answer

Processing in vba

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

Apr 1, 2023 in Others by narikkadan
 • 63,700 points • 250 views
0 votes
1 answer

How to calculate current streak of conditional number, and excluding blanks?

To solve this  use xmatch if it's ...READ MORE

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

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

Since WorksheetFunction.RTD() method (https://learn.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.rtd) signature (i.e.: how many parameters it is ...READ MORE

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

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

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

SEO - How to programmatically check if a website has been Banned by Google

i wanted to link a website to ...READ MORE

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

VBA Macro to add a relative reference column

You may accomplish this using an Excel ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,700 points • 249 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 • 249 views
0 votes
1 answer

Conditions in Excel: skip cells with dates without a year

Both Google Sheets and Excel save dates ...READ MORE

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

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

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