Trending questions in Edureka Community

0 votes
1 answer

Substring/Find last occurence of "/" and output everything to the right of it

Use TEXTAFTER() Function: =TEXTAFTER(B2,"/",-1) READ MORE

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

I keep getting a lot of errors on ChatGPT

Here are some of the common errors ...READ MORE

Feb 7, 2023 in ChatGPT by Elton
 • 400 points • 3,514 views
0 votes
1 answer

Differences between git pull origin master & git pull origin/master

To answer your question, the git pull ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,690 points • 19,109 views
0 votes
1 answer

Adding a splash screen to Flutter apps

To add a splash screen to your ...READ MORE

Mar 18, 2023 in Android by anonymous
 • 2,010 views
0 votes
0 answers

What are the roles and responsibilities of Research and Development Manager

Multiple crucial tasks are carried out by ...READ MORE

Apr 14, 2023 in Career Counselling by anonymous
edited Mar 5, 2025 • 701 views
0 votes
1 answer

What is Artifacts in DevOps?

In the context of DevOps, artifacts are ...READ MORE

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

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,189 views
0 votes
1 answer

Adjacent excel cells show same cell address on using =cell("address") formula.

Use the reference argument: =CELL("address",L54) From the docs: reference: The cell that you ...READ MORE

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

Export multiple worksheets without formula with the ability to select exact sheets and location

Try this: Sub ExportSheets() Dim ...READ MORE

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

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 3,343 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 • 460 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,342 views
0 votes
1 answer

nodejs mysql Error: Connection lost The server closed the connection

Try to use this code to handle server disconnect: var ...READ MORE

Jun 17, 2022 in Node-js by Neha
 • 9,020 points • 13,624 views
0 votes
1 answer

Macro throwing error when run from customized ribbon

The original macro was created in an ...READ MORE

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

allowing a third party application to write to your aws bucket

To grant access to a third-party developer ...READ MORE

Jun 20, 2023 in AWS by Khan Sarfaraz
• 700 points • 1,755 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,548 views
0 votes
0 answers

Name must follow the pattern

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

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

Processing in vba

Try this: Option Explicit Sub Macro2() ...READ MORE

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

Extracting a Variable Number of Letters from a Formula using VBA Code

Please, try the next function: Function extractLetter(rng As ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,449 views
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,191 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,428 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,854 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,414 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 • 678 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
 • 3,147 views
+2 votes
0 answers

iOS Instagram login get Instagram user id?

I am writing an iOS app that ...READ MORE

Nov 15, 2022 in Mobile Development by gaurav
 • 25,260 points • 2,908 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,556 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,738 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,730 points • 1,687 views
0 votes
1 answer

iCell.Value takes too long

Please try the following modified code. The ...READ MORE

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

Is Flutter/Dart valuable in the professional setting?

Yes, Flutter and Dart are valuable skills ...READ MORE

Mar 21, 2023 in Flutter by vani
 • 1,638 views
0 votes
0 answers

How can I access http://localhost/wordpress/wp-admin/install.php?

WordPress is running on localhost for me ...READ MORE

Aug 6, 2022 in PHP by Kithuzzz
 • 38,000 points • 11,472 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,373 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,730 points • 1,672 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,709 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,704 views
0 votes
1 answer

Error:Failed to open stream : No such file or directory.

Hello @kartik, Go to the file to include ...READ MORE

Oct 1, 2020 in PHP by Niroj
 • 82,800 points • 40,509 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,356 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 • 642 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,484 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,136 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,177 views
0 votes
0 answers

could not extract ResultSet in hibernate

I am getting this exception: "HTTP Status ...READ MORE

May 20, 2022 in Java by Kichu
 • 19,040 points • 10,862 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,478 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,432 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,690 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,638 views
0 votes
1 answer

All Levels of a Factor in a Model Matrix in R

Yes, you can modify the model.matrix() function ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 5,066 views
0 votes
1 answer

TODAY() function not working in Microsoft Excel

Works as shown: Just note that cell c1 ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,846 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,370 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.