Trending questions in Edureka Community

0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Try this: =QUERY(QUERY({QUERY('Movimentações'!A2:J,"Select F,C,D,E,(I*-1),(I*-1*J),(I*0),(J*0) where A matches 'Venda' ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 997 views
0 votes
1 answer

What is one key purpose of DevOps?

DevOps is a set of practices that ...READ MORE

Mar 23, 2023 in DevOps & Agile by Edureka
 • 13,720 points • 1,517 views
0 votes
1 answer

Count unique matches between two rows in Excel

The formula should be (in Excel 365) =SUM(--(COUNTIF(Draws!$B$2:$G$18,B2:K2)>0)) so ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,208 views
0 votes
1 answer

VBA - Insert Spilt Cell Value

Your desired outcome will not be produced ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 989 views
0 votes
1 answer

What makes Flutter unique?

Flutter is unique because it allows for ...READ MORE

Mar 20, 2023 in DevOps & Agile by vishalini
 • 1,547 views
0 votes
1 answer

Run time error 3343 unrecognized database format

Try using ADODB. Option Explicit Sub Export1line() ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,278 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

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

VBA - Build an Array by Looping Through Another Array with Specific Criteria

Please attempt the next option. It is ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 86,360 points • 1,359 views
0 votes
2 answers

Which industries use AI and Machine Learning?

AI is used in various industries like ...READ MORE

Jun 19, 2024 in Machine Learning by anonymous
 • 610 points • 2,200 views
0 votes
0 answers

Why does running a nginx image in docker interactive mode makes nginx not working?

I have made a docker container from ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited Mar 5, 2025 • 471 views
0 votes
1 answer

List Fridays and Saturdays in excel

 Try this: =TEXT(FILTER(SEQUENCE(DAY(EOMONTH(A4,0)),,EOMONTH( ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,006 views
0 votes
1 answer

Look at first empty row after the first few rows of my excel are empty, but the rest are populated

Concatenate If Not Blank Replace the J with I to replace as ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,044 views
0 votes
1 answer

See cell content instead of formula in formulabox in Excel using VBA

A VBA Lookup: Lookup Headers in an ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,173 views
0 votes
1 answer

How to read an Excel CSV file in Python?

The csv module or the pandas library ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,516 views
0 votes
1 answer

I want to switch my career from QA tester to DevOps. Is it good? What are the courses that I can take for DevOps?

Switching your career from a QA tester ...READ MORE

Mar 23, 2023 in DevOps & Agile by Edureka
 • 13,720 points • 1,478 views
0 votes
1 answer

Why does difference between same dates shows a difference of 1 month in Excel?

That's because you formatted the output using ...READ MORE

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

Highlight duplicates with only 2 colors

Try this: Sub ColorCompanyDuplicates2() 'best practice to define all ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,166 views
0 votes
1 answer

How to assign assign condition using if statement and VLOOKUP?

You can use either XLOOKUP() or INDEX() with MATCH() Function. • Formula used in ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,206 views
0 votes
1 answer

xlsxwriter formatting is corrupting my excel file

The problem is that while attempting to ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 5,010 views
0 votes
1 answer

How to merge the Two Columns with two different Tables without getting duplicates in either of the resulting columns

Assume your tables as named are read ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,507 views
0 votes
0 answers

Mailer Error: SMTP connect() failed in php mailer( https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting)

Here is code for sending email from ...READ MORE

Jun 2, 2022 in PHP by Kichu
 • 19,040 points • 14,077 views
0 votes
0 answers

How do I do this?

READ MORE

Apr 6, 2023 in Ask us Anything! by Kornelija
edited Mar 5, 2025 • 766 views
0 votes
1 answer

VBA Macro Iteration

Try this: Sub macro1() ' Macro1 Macro ' Dim ws As ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 86,360 points • 1,452 views
0 votes
0 answers

How to extract text from pdf and copy to system clipboard ?

Pdf is generated in ui and we ...READ MORE

Apr 5, 2023 in Selenium by Kaviya
edited Mar 5, 2025 • 786 views
0 votes
0 answers

Laravel Minio Temporary URL

I'm looking for a hacky way to ...READ MORE

Feb 14, 2023 in Others by Ashwini
 • 5,430 points • 2,171 views
0 votes
0 answers

Azure DevOps configuration with Jenkins

Can anyone help me how I can ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,730 points
edited Mar 5, 2025 • 435 views
0 votes
0 answers

K8S: How to manage incoming traffic for multiple instances of the same app with isolated namespaces and unique subdomains using an Ingress Controller?

I am new to K8S and need ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited Mar 5, 2025 • 430 views
0 votes
0 answers

Can I able to switch my career from QA tester to DevOps?

Is it possible to switch my career ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,730 points
edited Mar 5, 2025 • 426 views
–1 vote
1 answer

How can i make money from ChatGPT?

As an individual user, you cannot directly ...READ MORE

Feb 15, 2023 in ChatGPT by anonymous
 • 2,894 views
0 votes
1 answer

VBA - Msgbox inside a Loop

 Try this: Private Sub CommandButton1_Click() ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,483 views
0 votes
1 answer

Excel - How do I round a date type to the next hour if it is more than one minute

Add almost 30 minutes and it'll get ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,138 views
0 votes
1 answer

How do I build a loop into this TimeStamp VBA Code?

As Target is a range, it may ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,092 views
0 votes
1 answer

How to run code after some delay in Flutter?

You can use the Future.delayed method to ...READ MORE

Mar 10, 2023 in Android by vinayak
 • 1,866 views
0 votes
1 answer

Use python extract images from Excel sheets

I found a solution # installing the modules pip3 ...READ MORE

Apr 11, 2022 in Database by gaurav
 • 23,580 points • 16,336 views
0 votes
1 answer

Opt out or How to stop google bot accounts from my app?

It sounds like you are experiencing an ...READ MORE

Mar 18, 2023 in Android by pooja
 • 1,577 views
0 votes
1 answer

Count number of equal values in two rows in Excel

 Use this formula: =SUM(--(A2:E2=$A$1:$E$1)) READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,384 views
0 votes
0 answers

GitLab CI/CD: How do I generate a change log between pipeline runs?

I'm currently using Gitlab CI/CD combined with ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited Mar 5, 2025 • 404 views
0 votes
1 answer

Open Workbook on new instance

It must function. You aren't opening the Workbook ...READ MORE

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

Excel, unable to update count

Try this: • Formula used in cell J14 =COUNTIFS($F:$F,$I14,$H:$H,K$13) Fill Down ...READ MORE

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

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

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

Excel VBA code not running using F5 only F8

Change your code like this: Dim LastColumn As ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,368 views
0 votes
0 answers

Is it a good choice to go for DevOps from a system admin? What are the basic tools one should know?

Is shifting from S0ystem Admin role to ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,730 points
edited Mar 5, 2025 • 392 views
0 votes
0 answers

How do I switch my career from QA tester to DevOps?

How can I switch my career from ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,730 points
edited Mar 5, 2025 • 391 views
0 votes
0 answers

How can a Linux System Administrator switch to a DevOps profile/job?

Can a Linux System Admin switch to ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 13,720 points
edited Mar 5, 2025 • 390 views
0 votes
1 answer

Issues with NULL in an added and custom column

Try this: Fonte = ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,227 views
0 votes
0 answers

What are the different job roles one can apply by doing DevOps course?

What are the various job roles one ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 13,720 points
edited Mar 5, 2025 • 382 views
0 votes
0 answers

docker prune all images but keep images downloaded or created less than 48 hours ago?

Problem we're trying to overcome: We'd like ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited Mar 5, 2025 • 380 views
0 votes
0 answers

How do I switch to DevOps from Automation Testing?

Could someone tell me how to switch ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 13,720 points
edited Mar 5, 2025 • 382 views
0 votes
0 answers

What are the job opportunities for a devops engineer?

What job roles are provided to a ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 13,720 points
edited Mar 5, 2025 • 380 views
0 votes
1 answer

VBA Macro to add a relative reference column

You may accomplish this using an Excel ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,174 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.