Trending questions in Edureka Community

0 votes
0 answers

"Develop a python program to print square root of every alternate number in the range 1 to 15." What Do You Mean by alternate number?

My most recent computer test had a ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4, 2025 • 696 views
0 votes
0 answers

How can I use a Linked List in Python?

How can I utilise a linked list ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 4, 2025 • 653 views
0 votes
0 answers

How to convert list to string [duplicate]

How can I use Python to turn ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4, 2025 • 696 views
0 votes
1 answer

Attributing the value of a cell based on another corresponding cell

Put in cell B1 of Sheet1: =INDEX(Sheet2!B:B;MATCH(A1;Sheet2!A:A;0)) Drag it ...READ MORE

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

VBA Loop To Import Changing File Names

You can use a FOR loop and ...READ MORE

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

I am trying to configure and install puppet on a slave node but to no avail. The error message is shown below.

+ sudo dpkg -i puppetlabs-release-pc1-xenial.deb sudo: no tty ...READ MORE

Feb 9, 2023 in Puppet by Ferdinand

edited Mar 4, 2025 • 1,000 views
0 votes
1 answer

FilterOn and DynamicCriteria allowed values for MS Graph Excel Filter Criteria

The filtering criteria applied to a column ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
• 2,346 views
0 votes
0 answers

Base language of Python

What is the base language used to ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4, 2025 • 682 views
0 votes
1 answer

How can a column be set to display multiple spaces and tabs (white space) in a cell?

By entering your "code" in Word and ...READ MORE

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

Multiplication or sum of two numbers

Given two integer numbers, return their product ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 4, 2025 • 637 views
0 votes
0 answers

The AWS Access Key Id you provided does not exist in our records

I am getting invalid aws access key ...READ MORE

Dec 22, 2022 in AWS by Tejashwini
• 5,380 points
• 3,096 views
0 votes
1 answer

VBA How To Paste With Blank One Column Over?

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

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

Get inserted image to adjust the row height in Excel

Try this: 'just find Photo1 cell and select ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 86,360 points
• 1,640 views
0 votes
0 answers

Merge rows based on value (pandas to excel - xlsxwriter)

I'm attempting to use xlsxwriter to output ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
• 5,227 views
0 votes
1 answer

VBA copy data from other file - problem with file name change

To look for the source file, use ...READ MORE

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

Error in the angular compiler requires typescript >=3.4.0 and <3.6.0 but 3.9.10 was found instead

Run this script to find exact version npm ...READ MORE

Aug 3, 2022 in TypeSript by Abhinaya
• 1,160 points
• 9,147 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
• 86,360 points
• 1,241 views
0 votes
0 answers

How can I take the square root of -1 using python?

When I take the square root of ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 5, 2025 • 610 views
0 votes
0 answers

Print series of prime numbers in python

I was having trouble printing a run ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 5, 2025 • 606 views
0 votes
0 answers

How to declare and add items to an array in Python?

I'm trying to add items to an ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4, 2025 • 649 views
0 votes
0 answers

TypeError: Router.use() requires middleware function but got a Object

There were some changes made in the ...READ MORE

May 12, 2022 in Java-Script by Kichu
• 19,040 points
• 10,146 views
0 votes
1 answer

How to print SQL statement in codeigniter model

To display the query string: print_r($this->db->last_query()); ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 86,360 points
• 7,205 views
0 votes
1 answer

Is it possible to see more than 65536 rows in Excel 2007?

Here is an interesting blog entry about the ...READ MORE

Dec 10, 2022 in Others by narikkadan
• 86,360 points
• 3,571 views
0 votes
1 answer

VBA, Loop through sheets not detecting parameters?

Rewriting to prevent in addition to removing ...READ MORE

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

Vlookup error when lookup value cell has been populated with formula

Your formula returns 4 characters. =LEFT(M8,FIND(" ",M8)-1) will return ...READ MORE

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

Typescript: Debug Failure. False expression: Non-string value passed to `ts.resolveTypeReferenceDirective`

The same as a couple of days ...READ MORE

Aug 3, 2022 in TypeSript by Abhinaya
• 1,160 points
• 9,131 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
• 86,360 points
• 1,374 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
• 86,360 points
• 1,671 views
0 votes
1 answer

Exporting HTML Table to Excel Extension Issues

In my application, I'm experiencing a similar ...READ MORE

Nov 14, 2022 in Others by narikkadan
• 86,360 points
• 4,652 views
0 votes
0 answers

how to list GCP Project in subfolders

Hi, I want to list all GCP projects ...READ MORE

Feb 15, 2023 in GCP by MGX

edited Mar 4, 2025 • 676 views
0 votes
1 answer

Excel - how to calculate sum of multiple rows into different columns

The AutoSum button or formula can be ...READ MORE

Apr 4, 2022 in Database by Edureka
• 13,690 points
• 14,383 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
• 1,622 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

Jan 9, 2023 in Others by narikkadan
• 86,360 points
• 2,223 views
0 votes
1 answer

How to open a Bootstrap 4 modal dialog using jQuery

Use the modal('show') Method You can simply use ...READ MORE

Jun 28, 2022 in JQuery by rajatha
• 7,680 points
• 11,082 views
0 votes
1 answer

How to make a auto counter to print pages

This will loop through all of those ...READ MORE

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

Excel COUNTIFS with merged cell

Although it is strongly advised to stay ...READ MORE

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

Excel formula returning multiple values according to two criterias

Unique Column Cells With Two-Column Duplicates =LET(rCol,F2:F16,uCol1,G2:G16,uCol2,H2:H16, ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 86,360 points
• 1,470 views
0 votes
0 answers

Factorial program in android

Hey guys, I am aware that there ...READ MORE

Sep 21, 2022 in Android by Edureka
• 13,800 points
• 6,964 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

Dec 17, 2022 in Others by narikkadan
• 86,360 points
• 3,194 views
0 votes
0 answers

Are there any services like Databricks but without compulsion of AWS/Azure/Google Cloud?

I'm doing a course on Udemy for ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 5,380 points
• 1,567 views
0 votes
0 answers

Amplify pull --sandboxId <UUID> results in "Failed to pull sandbox app"

I'm trying to generate the data models ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 5,380 points
• 1,563 views
0 votes
1 answer

Use python to remove blank cells from column and shift populated cells up

Use pandas to import and modify your excel. import pandas ...READ MORE

Dec 10, 2022 in Others by narikkadan
• 86,360 points
• 3,712 views
0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 86,360 points
• 2,006 views
+3 votes
3 answers
0 votes
1 answer

Create Drop-Down List Using a Formula (Without Data Validation)

As far as I am aware, it ...READ MORE

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

Excel If duplicate agree paste the value

With Office 365: =LET( nm,A2:A5, ...READ MORE

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

How to freeze the =today() function once data has been entered

Don't enter this formula: =TODAY() Instead use  Ctrl + ; This will put a "frozen" ...READ MORE

Dec 17, 2022 in Others by narikkadan
• 86,360 points
• 3,155 views
0 votes
1 answer

Comparing data in Excel

A quick and mildly dirty VBA approach. ...READ MORE

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

Repercute value on other sheet with "auto-detect"

Try in K9: =INDEX(IFNA(VLOOKUP(C9:C; Sheet2!B:H; 7; 0))) READ MORE

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

How to improve VBA Code for Monte Carlo Simulation?

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

Jan 10, 2023 in Others by narikkadan
• 86,360 points
• 2,112 views