Most viewed questions in Others

0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 63,620 points • 673 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,620 points • 673 views
0 votes
1 answer

Looping through a folder with Excel files and scraping date from selected cells usin VBA

You record the outcome of your comparison ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 63,620 points • 672 views
0 votes
0 answers

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

Jul 18, 2021 in Others by Sri
 • 3,190 points • 671 views
0 votes
1 answer

Still getting warning : Configuration 'compile' is obsolete and has been replaced with 'implementation'

 For me, I was facing this similar ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,670 points • 670 views
0 votes
1 answer

Excel Nested IF INDEX MATCH Function

Use COUNTIF and an array if all ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,620 points • 669 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

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

Jan 24, 2023 in Others by narikkadan
 • 63,620 points • 669 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
 • 63,620 points • 669 views
0 votes
1 answer

Convert xls to csv without any data changes

Here are the 3 solutions I have ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 669 views
0 votes
0 answers

Error : Program type already present: android.support.design.widget.CoordinatorLayout$Behavior

I am getting this error while trying ...READ MORE

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

DynamoDB table design for notifications

Technologies used: AWS, Lambda, DynamoDB, Python. I am ...READ MORE

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

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Solution Find the last row. Write a formula to ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,010 points • 666 views
0 votes
1 answer

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 662 views
0 votes
1 answer

Spire When Pdf-ing an excel file it leaves some formulas as System.Object[][]

Since you tested the Excel file and ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,620 points • 661 views
0 votes
0 answers

How implement SEO (Metatags) in Angular 2 (with Angular universal for rendering on server side)?

I'm searching a fully working example about ...READ MORE

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

How to add SEO properties in sitemap using xml

i think your layout of the sitemap ...READ MORE

Feb 12, 2022 in Others by narikkadan
 • 63,620 points • 658 views
0 votes
1 answer

Open Existing PowerPoint via VBA

You do not have the proper reference ...READ MORE

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

VBA runtime error 1004 when copy and pasting

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

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

What is Sixth Sense Technology?

The sixth sense is a wearable gesture ...READ MORE

Apr 4, 2019 in Others by Alok
 • 656 views
0 votes
1 answer

Amortization schedule for many rows using Excel Macro

Try this: Sub one() Dim intRate, loanLife, initLoan, payment ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,620 points • 655 views
0 votes
0 answers

Regular Expression for alphanumeric and underscores

I wanted to have a regular expression ...READ MORE

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

Excel VBA - Delete empty rows

Try this: sub foo() dim r As ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 63,620 points • 654 views
0 votes
0 answers

How to create. A schema for DTP?

Dynamic Trunking Protocol is CISCO proprietary protocol ...READ MORE

Mar 1, 2020 in Others by RishabhJain
 • 120 points
recategorized Mar 2, 2020 by Gitika • 653 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

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

How to use count and group by at the same select statement

This will do what you want (list of ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,260 points • 651 views
0 votes
1 answer

Excel to PDF C# library

These articles will be help for you ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 63,620 points • 651 views
0 votes
0 answers

what does bash: /home/XXX/.rvm/scripts/rvm: No such file or directory mean?

I was installing the ruby on rails ...READ MORE

May 26, 2022 in Others by Ashwini
 • 5,430 points • 650 views
0 votes
1 answer

React Server Components Performance on SEO

const html = readFileSync(       path.resolve(__dirname, '../build/index.html'),       'utf8'     );     // Note: this ...READ MORE

Feb 25, 2022 in Others by narikkadan
 • 63,620 points • 649 views
0 votes
1 answer

How do I get a cheap domain name? - web hosting

Many web hosting companies like amazon's lighsail ...READ MORE

Oct 28, 2019 in Others by Yesha
 • 649 views
0 votes
1 answer

I Get "object required" error when using getElementByID

As you see LoginID is the id of the ...READ MORE

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

How to change compound annual growth rate (CAGR) formula depending on data existing/not existing?

Sep to calculate CAGR. Excel has an ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,620 points • 647 views
0 votes
1 answer

Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 63,620 points • 647 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,620 points • 647 views
0 votes
1 answer

How to trigger Excel AutoFill using power Automate?

In PAD you may want copy the ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,620 points • 647 views
0 votes
0 answers

Upgrade instance type from r4 to r5 in AWS RDS

I am currently using an r4 instance. Model ...READ MORE

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

Excel Get different permutation combination of the values

This work can be completed utilising dynamic ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,620 points • 646 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,620 points • 646 views
0 votes
0 answers

Eclipse internal error while initializing Java tooling

I am getting this error: An internal ...READ MORE

May 17, 2022 in Others by Kichu
 • 19,050 points • 646 views
0 votes
0 answers

How to disable Amazon S3 raw endpoint access

Hosting  a static website on S3 : You ...READ MORE

Apr 10, 2022 in Others by Kichu
 • 19,050 points • 646 views
0 votes
0 answers

How to make grid view scroll horizontally not vertically in android?

I have a dynamic Grid View. If ...READ MORE

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

Different types of AI

Following are the different types of AI: Reactive ...READ MORE

Apr 18, 2019 in Others by John
 • 645 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,620 points • 643 views
0 votes
1 answer

Rounded corners on iOS 13 page sheet

You can alter the view controller in ...READ MORE

Sep 20, 2022 in Others by Aditya
 • 7,680 points • 642 views
0 votes
0 answers

how to import jar in Mac

Jul 7, 2019 in Others by anonymous
 • 642 views
0 votes
1 answer

Flutter - seo optimization

the best way is to apply the ...READ MORE

Feb 20, 2022 in Others by narikkadan
 • 63,620 points • 640 views
0 votes
1 answer

I want workshop recordings because missed it due to some work. Registered for "Edureka CIoud Workshop - Build a Smarter ChatBot with AWS" conducted on 20 and 21st June

Hey, @Tanush  If you have already registered for ...READ MORE

Nov 9, 2020 in Others by Edureka
 • 640 views
0 votes
1 answer

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 63,620 points • 638 views
0 votes
1 answer

Find duplicates in a column

If any cells in column "F" contain ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,620 points • 638 views
0 votes
1 answer

Writing SEO friendly url gets infinite loop asp.net

you should know that regex avoid cases ...READ MORE

Feb 11, 2022 in Others by narikkadan
 • 63,620 points • 638 views
0 votes
1 answer

Best WooCommerce Plugin for B2B eCommerce Website?

Check this out https://woocommerce.com/products/b2b-for-woocommerce/ READ MORE

Sep 30, 2020 in Others by anonymous
 • 19,610 points • 638 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.