Trending questions in Edureka Community

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
 • 86,360 points • 2,941 views
0 votes
1 answer

Unable to download excel file from src/assets in development/qa/prod environment for angular application

Try this: this.HttpClient.get("./assets/sample.xlsx",{responseType: "blob"}).subscribe((res:any) => ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 6,096 views
0 votes
1 answer

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

The values you wish to display in ...READ MORE

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

Microsoft Visio Database add-in - Reverse Engineer of Azure Sql Server only showing 'master' Database and no others

I'm trying to target one of our ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 2,038 views
0 votes
1 answer

VBA How do I replace the range with an array in SUMIF

You can't, in my opinion. When you ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 2,325 views
0 votes
0 answers

How to handle amazon cognito authentication pop-up using java selenium.

I have a website where post clicking ...READ MORE

Mar 16, 2023 in Selenium by anonymous
edited Mar 5, 2025 • 744 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

The following should function if you actually ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 2,150 views
0 votes
0 answers

Testing & Deploy Azure Data Projects

As an Azure developer and data engineer, I enjoy automating cloud deployments and testing.  I'm currently working with a number of Azure resources, including SQL Server, PowerBI, Azure Data Factory, Azure Data Lake Storage, and Azure Data Lake Analytics. Doing some research I've found a bunch ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 2,030 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 4,304 views
0 votes
1 answer

Name not recognized error in List.Generate

Try this: let Source = < >, columnsToExpand ...READ MORE

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

iOS 13 Custom Fonts download and installation

Step 1: From the Home screen, tap ...READ MORE

Dec 15, 2022 in Mobile Development by gaurav
 • 25,250 points • 5,107 views
0 votes
0 answers

phpmyadmin Failed to set session cookie. Maybe you are using HTTP instead of HTTPS

I successfully installed PHP, Apache, and MySQL. ...READ MORE

Jul 28, 2022 in PHP by Kithuzzz
 • 38,000 points • 10,714 views
0 votes
1 answer

How to add column filters to Excel worksheet using XLWINGS?

Call the API property to activate the autofilter: import xlwings ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 4,284 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 17,335 views
0 votes
2 answers

Sigma code look like this but it’s not working.

ok so u need add a sigma ...READ MORE

Mar 20, 2025 in Python by anonymous
 • 3,114 views
0 votes
0 answers

What is the difference between Python's list methods append and extend?

What's the difference between the list methods append() a ...READ MORE

Mar 15, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 735 views
0 votes
1 answer

Find max and second max salary for a employee table MySQL

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 6,280 views
0 votes
1 answer

How to hide blank rows in an excel form if they are blank

If an empty row should be defined ...READ MORE

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

How to reference an excel sheet by variable

Identify Worksheet By Partial Name Sub SelectByMonth() ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 1,829 views
0 votes
0 answers

Python - Count how many times keywords stored in a list appear in text

I have a list KeywordList of 20k+ ...READ MORE

Mar 16, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 675 views
0 votes
0 answers

Convert decimal to binary in python

Is there any module or function in ...READ MORE

Mar 15, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 705 views
0 votes
0 answers

chmod: changing permissions of 'cilocks': Operation not permitted

how do i resolve the error READ MORE

Mar 17, 2023 in Cyber Security & Ethical Hacking by frank
edited Mar 5, 2025 • 647 views
0 votes
0 answers

Crop a video in python

I am wondering to create a function ...READ MORE

Mar 16, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 666 views
0 votes
0 answers

Why do Python classes inherit object?

Why does the following class declaration inherit ...READ MORE

Mar 16, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 666 views
0 votes
0 answers

which phase of software production are the focus of devops?

Which phase(s) of software products are the ...READ MORE

Dec 22, 2022 in DevOps & Agile by Edureka
 • 13,800 points • 4,121 views
0 votes
0 answers

Deployment dependencies condition skipped azure pipeline.

I built a pipeline. There are two ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 3,677 views
0 votes
1 answer

Tableau For Loop a String

In the case of [ { ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,657 views
0 votes
0 answers

What is the most efficient way of finding all the factors of a number in Python?

Can someone explain to me an efficient ...READ MORE

Mar 16, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 641 views
0 votes
1 answer

How do I output the row containing the lowest value from a specific column inside a filtered dynamic array?

Instead of using 1 filter function to ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,251 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
 • 86,360 points • 1,605 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 • 1,731 views
0 votes
1 answer

Why my new server shows numbers in the URL address?

It looks like the URLs for your ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 1,773 views
0 votes
1 answer

How do I copy a specific range of cells after I use AutoFilter in VBA?

Set the range of filtered data Set Rng ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 2,402 views
0 votes
0 answers

Azure Data Engineer Associate certificate - preparation, Microsoft learn platform

Has anyone tried using Microsoft's online training ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,901 views
0 votes
0 answers

How can I get the source code of a Python function?

Suppose I have a Python function as ...READ MORE

Mar 16, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 611 views
0 votes
1 answer

Using VBA Workbook_SheetChange only works in one direction

You are making heavy use of Target.Address ...READ MORE

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

Excel - count if multiple words are in a cell

Try this using wildcards * with TEXTBEFORE()&nb ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,622 views
0 votes
0 answers

How do I count the occurrences of a list item?

Given a single item, how do I ...READ MORE

Mar 15, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 642 views
0 votes
0 answers

Best way to keep Azure Postgres in sync with Azure SQL

For the use of pretty much everything, ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,892 views
0 votes
1 answer

Excel formula in Pandas

 Use this: df['col2'] = df['col1'].shift().lt(df['col1']).astype(int) I hope this helps ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 3,560 views
0 votes
0 answers

What do the python file extensions, .pyc .pyd .pyo stand for?

What do these python file extensions mean? .pyc .pyd .pyo What ...READ MORE

Mar 15, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 635 views
0 votes
1 answer

How to split column into two

Using WRAPSROWS() • Formula used in cell C2 --> Exclusively Applicable To ...READ MORE

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

How do I get a “select count(*) group by” using laravel eloquent?

Hello @kartik, You could use this: $reserves = DB::table('reserves')->selectRaw('*, ...READ MORE

Oct 21, 2020 in Laravel by Niroj
 • 82,800 points • 38,386 views
0 votes
1 answer

Excel number format: scale number by ten thousand or hundred thousand

In the MSExcel spreadsheet, Right Click on ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 7,008 views
0 votes
0 answers

Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V

While initializing derby with bin/schematool -initSchema -dbType derby it ...READ MORE

Mar 14, 2023 in Others by Prashant
edited Mar 5, 2025 • 669 views
0 votes
0 answers

List vs tuple, when to use each?

In Python, when should you use lists ...READ MORE

Mar 15, 2023 in Python by Arya
 • 990 points
edited Mar 5, 2025 • 620 views
0 votes
1 answer

Concatenate only upper case letters?

In ms365, try: The formula in B1‡: =CONCAT(TEXTSPLIT(A1,TEXTSPLIT(A1,CHAR(ROW(65:90)),,1))) ‡ If not a ...READ MORE

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

SSIS Excel Connection Manager failed to Connect to the Source

It seems like the 32-bit version of ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 86,360 points • 6,559 views
0 votes
0 answers

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 2,572 views
0 votes
1 answer

How to sum the next n non-empty cells in LibreOffice Calc?

Here's a volatile solution (assuming you don't ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 2,489 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.