Trending questions in Edureka Community

0 votes
1 answer

Excel If Statement with Wildcards and Value Search

Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,519 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,694 views
0 votes
0 answers

Not able to connect remote host via jenkins to run ansible playbook.

Not able to connect remote host via ...READ MORE

Apr 10, 2023 in Jenkins by anonymous
edited Mar 5, 2025 • 1,197 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,777 views
0 votes
1 answer

Excel Pivot Table : Calculated Field ( formula to be used like sumproduct)

With a calculated field, you might not ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 5,357 views
0 votes
1 answer

Reading Excel file Date/time Incorrectly

Use dateutil.parser. Example usage: import dateutil.parser as parser parser.parse("2021-04-04 00:00:00 1900-01-01 ...READ MORE

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

How to solve "Error: Apache shutdown unexpectedly"?

To answer your question, as this port ...READ MORE

Feb 10, 2022 in Others by Rahul
 • 9,690 points • 19,452 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
 • 2,214 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,440 points • 2,780 views
0 votes
1 answer

Excel - allow result to change if value is greater than

Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,456 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 • 11,270 views
0 votes
1 answer

VBA & Ascii Art

This is possible with a two-dimensional array. ...READ MORE

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

invalid literal for int() with base 10: '1 2 3 4 5'

def strictlyInc(l):     for i in range(len(l)-1):         if l[i]>l[i+1]:             return "No"             break     return ...READ MORE

Apr 22, 2023 in Python by anonymous
edited Mar 5, 2025 • 635 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 • 988 views
0 votes
0 answers

Need help on the following questions

Hi, I have a dataset related to ...READ MORE

Apr 12, 2023 in Tableau by Prakash
edited Mar 5, 2025 • 1,071 views
0 votes
1 answer

How to find all internal ranges in a specified range

It is simple to compare once you ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,741 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,567 views
0 votes
1 answer

ActiveSheet.Hyperlinks.Add don't show Text To Display

Here's how Excel functions. Not a bug, ...READ MORE

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

Power Query - Search an element of column A in entire column B

The delta column in PowerQuery is calculated ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,604 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,859 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 • 3,238 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,856 views
0 votes
1 answer

User form to print an array of sheets

It appears that when a UserForm is ...READ MORE

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

Writing large Excel in Java causing high CPU usage using apache-poi

Giving SXSSFWorkbook a window size appears to ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 86,360 points • 4,178 views
0 votes
0 answers

asking about career advice

Hey, I completed my graduation in civil ...READ MORE

Apr 21, 2023 in Others by anonymous
edited Mar 5, 2025 • 649 views
0 votes
1 answer

How can I set a number for a public variable at userforms in excel?

Try: Public b As Integer Private Sub exa_Click() b = ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,754 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,703 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 • 2,039 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,487 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
 • 2,425 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,250 points • 3,202 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,946 views
0 votes
0 answers

Secure collaborative software development environment in the cloud

I am looking for a secure collaborative ...READ MORE

Apr 20, 2023 in Cyber Security & Ethical Hacking by Edureka
 • 12,710 points
edited Mar 5, 2025 • 674 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

In the stacktrace, there is a line ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 86,360 points • 9,954 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,419 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,800 points • 1,984 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,460 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 • 6,311 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,707 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,794 views
0 votes
0 answers

I get error “cannot read Pom.cal” when I run jenkinsfile even though Jenkins has permission and can open it

I have a Jenkins pipeline job. When ...READ MORE

Apr 19, 2023 in DevOps & Agile by Judith
edited Mar 5, 2025 • 682 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,488 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,824 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,996 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,777 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,985 views
0 votes
1 answer

Can I use ChatGPT to create chatbot on my website?

Yes, you can use ChatGPT to create ...READ MORE

Feb 15, 2023 in ChatGPT by anonymous
 • 3,352 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,923 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.