Trending questions in Edureka Community

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 • 551 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,726 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,458 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
 • 86,360 points • 2,709 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,678 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,111 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 • 560 views
0 votes
1 answer

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE

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

Python/Openpyxl: change cell A1 in all excel worksheets within a workbook to equal the name of the worksheet tab

You made a mistake when you used ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 5,602 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 • 519 views
0 votes
1 answer

What VBA Code to Hide Excel Quick Access Toolbar?

Use this: Sub HideQuickAccessTB() Application.ExecuteExcel4Macro ...READ MORE

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

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 2,092 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 • 549 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,079 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,790 points • 3,970 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 • 541 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,072 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 • 586 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 • 4,885 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 • 1,807 views
0 votes
1 answer

How to open a password protected excel file using python?

I recently came upon a Python package ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 25,250 points • 15,304 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,765 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,442 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,493 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,568 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,080 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,751 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,474 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,430 views
0 votes
1 answer

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 6,047 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,462 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,597 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,404 views
0 votes
3 answers

Command "python setup.py egg_info" failed with error code 1 in C:\Users\Nadeem\AppData\Local\Temp\

You have an out of date version ...READ MORE

Dec 15, 2020 in Python by Rajiv
 • 8,870 points • 40,635 views
+2 votes
2 answers

How do I undo something in Power BI?

To undo your last action or last few actions, press ...READ MORE

Oct 15, 2018 in Power BI by Hannah
 • 18,520 points • 37,503 views
0 votes
0 answers

What is the role of Advanced SME in Azure Synapse Analytics?

I watched a training video for Azure ...READ MORE

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

Input Box Date Validation

I have an update form for my ...READ MORE

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,172 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,206 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,768 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,036 views
0 votes
1 answer

Struggling to move object based on the value to respect sheet

If you are not moving many rows ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,682 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,407 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
 • 2,813 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,589 views
0 votes
1 answer

How to build a Python project for a specific version of Python?

To build a Python project for a ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 1,543 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,313 views
0 votes
0 answers

Getting error message about master.sys.sysclsobjs while converting SQL Server database to Azure

I have a database with SQL Server ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,679 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,181 views
0 votes
1 answer

VBA Create and Rename Tables

Convert Table to Excel Table (ListObject) Option Explicit Sub ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 2,561 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 • 6,790 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.