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 • 1,358 views
0 votes
0 answers

What is the single most influential book every programmer should read?

If you could go back in time ...READ MORE

Apr 20, 2023 in Cyber Security & Ethical Hacking by Edureka
 • 12,710 points
edited Mar 5, 2025 • 563 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,872 views
0 votes
1 answer

How to automatically get a specified range of data from Excel to XML in VBA

Range method works, always identify the sheet ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 2,371 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,800 points • 1,872 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,911 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,427 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 • 1,341 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,723 views
0 votes
1 answer

Excel VBA compare values on multiple rows and execute additional code

I would use a Dictionary & Collection ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 3,625 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,635 views
0 votes
1 answer

Autofill Copy down up until next empty row- Excel VBA Macro

Row 1048576 will be returned by end(xldown) ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 86,360 points • 3,144 views
0 votes
0 answers

How is marital status distributed each year? Did the number of single new hires increase or decrease historically?

How is marital status distributed each year? ...READ MORE

Apr 19, 2023 in Power BI by anonymous
edited Mar 5, 2025 • 558 views
0 votes
0 answers

bitbucket pipeline to push commits to another repo

So this is the scenario i have ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited Mar 5, 2025 • 814 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,791 views
0 votes
1 answer

Excel Script keeps giving error "Range merge: You cannot perform the requested operation."

Range.merge() Operation is not possible in ExcelScript ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 2,913 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,355 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,523 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,481 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,559 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,511 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,768 views
0 votes
0 answers

Name must follow the pattern

RROR: Name must follow the pattern '^[a-zA-Z0-9]+((\.|_|__|-+ ...READ MORE

Apr 17, 2023 in DevOps & Agile by Swapnil
edited Mar 5, 2025 • 604 views
0 votes
1 answer

Copy data with filter applied using Excel VBA

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

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,847 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 • 787 views
0 votes
1 answer

VBA Excel get data from Access database Error

Try this: Sub getdata() Const ...READ MORE

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

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Confusion: You must declare the parameter as ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 2,295 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,646 views
0 votes
1 answer

How to clear TextField Entered Text automatically in Flutter?

Hi@akhtar, You can control the TextField in your ...READ MORE

Sep 10, 2020 in Others by MD
 • 95,460 points • 41,542 views
0 votes
1 answer

Excel Date separate with =DAY(), =MONTH() and =YEAR()

If it must be done inside of ...READ MORE

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

Why does WinHTTPRequest responseText return a different value to MsgBox than Debug.Print dynamic web pages

The Immediate pane has a built-in limit ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 2,266 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,551 views
0 votes
0 answers

How to create Toast in Flutter

Can I create something similar to Toasts in Flutter? Just ...READ MORE

Mar 9, 2023 in Android by sarit
 • 1,830 points • 2,006 views
0 votes
1 answer

How can I remove the debug banner in Flutter?

The debug banner in Flutter can be ...READ MORE

Mar 1, 2023 in Android by vishalini
 • 2,544 views
0 votes
0 answers

Container logs for helm install

Is it possible to print to helm ...READ MORE

Mar 16, 2023 in DevOps & Agile by Edureka
 • 12,710 points • 1,743 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 • 1,069 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 • 719 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 • 1,035 views
0 votes
1 answer

Highlight cells in an Excel column if the value can be found in an array

Try this: =COUNTIFS(B:E,$A1) READ MORE

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

AES/CBC/PKCS5Padding in NodeJs

I am trying to convert my java ...READ MORE

Jun 23, 2022 in Node-js by Vaani
 • 7,070 points • 5,605 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 • 687 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 86,360 points • 4,248 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,710 points
edited Mar 5, 2025 • 680 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 4,547 views
0 votes
1 answer

What is the hype about flutter?

Flutter is a popular framework for building ...READ MORE

Mar 20, 2023 in DevOps & Agile by padma priya
 • 1,739 views
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 8,423 views
0 votes
1 answer

Issue with upgrading aws EC2 t2 machine to t3 or t3a

It sounds like the issue you are ...READ MORE

Feb 16, 2023 in AWS by anonymous
 • 3,085 views
0 votes
1 answer

AWS mTLS access to load balanced EC2 cluster

Yes, you are correct that API Gateway ...READ MORE

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

VBA - Build a Two-Column Array By Looping Through one Array with a Specific Criteria and Selecting From Another Array

As already mentioned as comment: Loop over ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,493 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,710 points
edited Mar 5, 2025 • 640 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.