Trending questions in Edureka Community

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

Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell?

Use the REPT function: =REPT("ABC",4) => ABCABCABCABC ...READ MORE

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

Creating sheets with names in column B and assigning data to each sheet for particular name

after the first occurrence of Set sht = ...READ MORE

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

Java 11 JDK for Windows 7 32-bit system

I wanted to install Java 11 on ...READ MORE

Apr 21, 2022 in Java by Rahul
 • 3,380 points • 5,735 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
 • 86,360 points • 2,014 views
0 votes
0 answers

how to know the day (is it Monday, Tuesday or...) of a specific date in Python

I have a pandas dataframe with one ...READ MORE

Mar 20, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 502 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 • 1,573 views
0 votes
1 answer

DMZ kind of network design in the AKS

It sounds like you want to implement ...READ MORE

Feb 17, 2023 in AWS by sarit
 • 1,830 points • 1,836 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 5,811 views
0 votes
0 answers

How to select the last record of a table in SQL?

Here is an example of code that ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,000 points • 2,338 views
0 votes
1 answer

Excel Count unique values beetween 2 columns

Try this : • Formula used in cell D3 =LET(x,UNIQUE( ...READ MORE

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

Android - Set text to TextView

After discovering the views, you set the ...READ MORE

Nov 10, 2022 in Android by Edureka
 • 12,730 points • 6,068 views
0 votes
1 answer

How to calculate median of unsorted values

In vba code: Dim r As Range Dim result 'Set ...READ MORE

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

Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

I'm trying to reverse-engineer an Azure SQL ...READ MORE

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

Conditional format based on external cell value

Use a rule with the formula =$Q6="Yes" and apply ...READ MORE

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

EXCEL: Count case sensitive criteria in one column if meets criteria in another column

You may try: The formula in B1: =MAP(A1:A12,LAMBDA(x,SUM(- ...READ MORE

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

how to use the Box-Cox power transformation in R

Yes, you are on the right track ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 3,947 views
0 votes
0 answers

Azure Vnet Private IP Ranges

I don't have experience in networking. I'm ...READ MORE

Feb 15, 2023 in Azure by Damonlang
 • 1,230 points • 1,884 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 • 639 views
0 votes
1 answer

Excel to Word Macro resulting in Run-time error 462

Are you attempting this (UNTESTED)? I've commented ...READ MORE

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

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Changed the following code: function BlazorDownloadFile(filename, bytesBase64) { var ...READ MORE

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

Open webpage in fullscreen in Safari on iOS

No, javascript cannot be used to switch ...READ MORE

Nov 4, 2022 in IOS by Rahul
 • 9,690 points • 6,296 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 • 602 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Try entering this code in Powerquery's input ...READ MORE

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

Fixed position but relative to container

The issue with "fixed" positioning is that ...READ MORE

Jun 28, 2022 in CSS by Edureka
 • 12,730 points • 11,819 views
0 votes
0 answers

How to create scatter plot in Tableau from database format?

How to create scatter plot in Tableau ...READ MORE

Feb 23, 2023 in Tableau by Tivadar
edited Mar 5, 2025 • 1,480 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 • 621 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 • 1,869 views
0 votes
0 answers

Design for a Cloud Native Application in Azure for ML Insights and Actions

I have a plan to create a ...READ MORE

Feb 15, 2023 in Azure by Damonlang
 • 1,230 points • 1,821 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,559 views
0 votes
1 answer

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 4,428 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 • 555 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 • 553 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 • 588 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 • 548 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 86,360 points • 8,535 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 • 517 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 • 516 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 • 1,803 views
0 votes
1 answer

Excel VBA - Out of memory when create a dynamic array formula

Try this: Sub MyArray() Range("A1").Formula2 = "=R[2]C[2]:R[2]C[6]" End Sub But that ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 86,360 points • 1,996 views
0 votes
0 answers

How to delete unwanted artifacts in Azure DevOps

Numerous NuGet packages are created by our ...READ MORE

Dec 13, 2022 in DevOps on Cloud by Edureka
 • 13,730 points • 4,506 views
0 votes
1 answer

Excel VBA Protect Sheet without Locking all cells

If the problem is the use of Clear then ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 3,813 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 • 523 views
0 votes
1 answer

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 6,642 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 • 484 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 • 513 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,052 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 • 1,878 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,625 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 • 556 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.