Most viewed questions in Others

0 votes
1 answer

Dropdown list circular reference Excel/VBA

Try this: Private Sub Workbook_SheetChange(ByVal Sh As Object, ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 86,360 points • 803 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
 • 86,360 points • 803 views
0 votes
1 answer

Which is better normal desktop window or MDI like excel and chronos

How people interact with your system entirely ...READ MORE

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

Export multiple worksheets without formula with the ability to select exact sheets and location

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

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 802 views
0 votes
1 answer

Reference Excel sheet number in an external workbook

Try this: Function SheetByCodeName(wb As Workbook, cn As ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
 • 38,000 points • 802 views
0 votes
0 answers

Excel: How to Sort or filter text by specific word or words?

Even if the term is used in ...READ MORE

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

Using VLOOKUP()

Vlookup takes the lookup value first, so ...READ MORE

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

Symfony2 / Sonata SEO Bundle / og:image

cdn: server: ...READ MORE

Feb 17, 2022 in Others by narikkadan
 • 86,360 points • 802 views
0 votes
1 answer

Excel If Functions with Multiple Conditions

Use this: =IF(C3<=0,"Green",IF(C3<500,"Silver",IF(C3<=1499,"Gold","Platinum"))) I added <=0 just in case you have ...READ MORE

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

Allow alpha numeric values instead of isnumeric

Here's a small Function you could add to your ...READ MORE

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

VBA to unhide a column when opening a workbook

Use the workbook_open even within ThisWorkbook. READ MORE

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

Combine two arrays

I have two arrays structures like this array( ...READ MORE

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

Can an "SEO Friendly" url contain a unique ID?

beware you can get penalised for duplicate ...READ MORE

Feb 17, 2022 in Others by narikkadan
 • 86,360 points • 798 views
0 votes
1 answer

Use AutoFilter on the current visible data

Use the following modified code. It's assumed ...READ MORE

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

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

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

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

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

SQL Server CASE .. WHEN .. IN statement

Try this... SELECT AlarmEventTransactionTableTable.TxnID, ...READ MORE

Jun 14, 2022 in Others by polo
 • 1,480 points • 796 views
0 votes
0 answers

How can i solve NoClassdeffoundError on my mobile?

Oct 15, 2019 in Others by SolomonTS
 • 120 points • 796 views
0 votes
1 answer

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

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

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

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

How to multiply by a percentage range in Excel

The following would yield an array from ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 795 views
0 votes
0 answers

AWS Lambda vs EC2: Which one to choose

I want to make login service that ...READ MORE

Apr 4, 2022 in Others by Kichu
 • 19,040 points • 794 views
0 votes
1 answer

How to compare 2 cells with delimited items in each and output the difference in items?

The following function would do this for ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 793 views
0 votes
1 answer

Simple question regarding PHP, Wordpress & Yoast SEO

the way the search engine displays your ...READ MORE

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

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 792 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
 • 86,360 points • 792 views
0 votes
1 answer

Reversing Text to Columns in Excel/Calc

There are built-in functions that will allow ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 792 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,000 points • 791 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 86,360 points • 790 views
0 votes
0 answers

can the font type of an Edittext,Radio Button and CheckBox be changed in Android

.I can able to change the font ...READ MORE

Jun 22, 2022 in Others by nisha
 • 2,210 points • 789 views
0 votes
1 answer

Excel grade formula

Since you said it was just for ...READ MORE

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

Creating a chart in VBA with 2 different Types

Can you carry this out by hand ...READ MORE

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

Insert Excel rows for each x in adjacent country columns to prepare Oracle Calendar Event Coverage uploadsheet

Create a table (insert > table) from ...READ MORE

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

Excel-How can I get the address of a cell instead of a value?

There are various difficulties in this. Which ...READ MORE

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

Show tick symbol on label

Try this code: LblTick.Text = ((char)0x221A).ToString(); Easier method: lblTick.Text ...READ MORE

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

VBA to create a dynamic rolling list of names

If I understand you correctly, a case. ...READ MORE

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

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

Consider using a fixed template for the ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 86,360 points • 785 views
0 votes
0 answers

How to create DropDown which have dynamic Validation List

In my data table, the columns "Category" ...READ MORE

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

What is Segmentation fault (core dumped)?

I  wrote this code in c in ...READ MORE

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

Better SEO to remove "stop" words from an article's URL Slug?

these words doesnt have much priority in ...READ MORE

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

VLOOKUP with date range does not work as intended

I have two excel tables in separate ...READ MORE

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

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

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

OR and IF function for multiple values

Your OR functions will always return TRUE ...READ MORE

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

Trying to run different macros based on value of cell in a range

This demonstrates one approach to loop through ...READ MORE

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

Shortcut to Apply a Formula to an Entire Column in Excel

Try double-clicking on the bottom right hand ...READ MORE

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

Googlebot is accessing .aspx pages, it should access SEO-friendly URLs only

the url mapping would be wrong that ...READ MORE

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

Maximum request length exceeded.

When I tried to upload a video ...READ MORE

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

Custom Request Matcher for SEOMOZ + VCR

record the time of the test in ...READ MORE

Feb 25, 2022 in Others by narikkadan
 • 86,360 points • 781 views
0 votes
0 answers

explain what access modifier can be used for method

Sep 10, 2019 in Others by anonymous
 • 781 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.