Trending questions in Edureka Community

0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Use InStr function to find the beginning of the ...READ MORE

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

Azure DevOps configuration with Jenkins

Yes, I can help you with that. To ...READ MORE

Apr 11, 2023 in DevOps & Agile by anonymous
 • 12,730 points
edited Mar 5, 2025 • 1,380 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Add column, custom column with formula: = try ...READ MORE

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

Formula in Excel with a particular increment value

I need to use Excel formulas for ...READ MORE

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

Create dependable dropdown of unique items in vba

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

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

For a cell that is consistent across ...READ MORE

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

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

SourceFolder is an object that only understands ...READ MORE

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

Best way to do nested case statement logic in SQL Server

Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 86,360 points • 9,642 views
0 votes
1 answer

How swap slots in azure devops?

Yes, you can swap the slots in ...READ MORE

Apr 11, 2023 in DevOps & Agile by anonymous
 • 12,730 points
edited Mar 5, 2025 • 1,308 views
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,184 views
+1 vote
1 answer

What are named routes in Laravel and How can specify route names for controller actions?

Hey @kartik, Named routing is another amazing feature of ...READ MORE

Mar 23, 2020 in Laravel by Niroj
 • 82,800 points • 48,843 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 • 363 views
0 votes
1 answer

Another method to extract the last row containing data in a column

The "used range" might not be accurate. ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,389 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,730 points
edited Mar 5, 2025 • 417 views
0 votes
1 answer

Click cell to generate dynamic table

Try the following: The formula in F1 (as per my ...READ MORE

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

How can I dismiss the on screen keyboard?

To dismiss the on-screen keyboard, you can ...READ MORE

Mar 1, 2023 in Android by vishalini
 • 2,527 views
0 votes
1 answer

What are projection and selection?

Projection means choosing which columns (or expressions) the query shall ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 86,360 points • 9,935 views
0 votes
1 answer

Violation Long running JavaScript task took xx ms

These messages are classified as warnings rather ...READ MORE

Nov 15, 2022 in Java by Damonlang
 • 1,230 points • 7,117 views
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE

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

How to detect value in change in excel using python?

You might keep a txt file with ...READ MORE

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

How to change date format from 201904 to Apr-19 in excel

This 201904 is recognised as a number ...READ MORE

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

How to turn a number recognized as string to number

Try this: =VALUE(SUBSTITUTE(A1," ", "")) Or select cells with ...READ MORE

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

How to transpose data in an other tab in excel

If you're using a previous version of ...READ MORE

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

Type the max number title in Excel

If you have duplicates and want to ...READ MORE

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

My VBA Addin creates a custom ribbon tab, but should only be visible for intended workbooks

The RibRefresh sub's logic is overly convoluted ...READ MORE

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

A button in excel sheet does not work for the first time

When you press the Display button, the ...READ MORE

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

Trying to redo my Export Button Function on my document

You could directly publish the data to ...READ MORE

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

Filter only certain columns in Excel Pivot Tables

Pivot Tables are mainly designed to create aggregated data from ...READ MORE

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

Validation of postcodes in several countries

When a value is made up entirely ...READ MORE

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

Why does this VBA Macro that copies and paste range into email in the wrong order?

When a message body is created by ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,626 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 • 386 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,730 points
edited Mar 5, 2025 • 348 views
0 votes
1 answer

Do you use Firebase for your flutter apps?

Firebase is a popular backend-as-a-service (BaaS) platform ...READ MORE

Mar 20, 2023 in DevOps & Agile by Anitha
 • 1,704 views
0 votes
0 answers

What good technology podcasts are out there?

Yes, Podcasts, those nice little Audiobooks I ...READ MORE

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

Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

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

VBA how to calculate depth of items in excel, simliar to a BOM system

Add on the sheet an ActiveX Microsoft ...READ MORE

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

Vba range object single column autofill

Just refer to the first column of rng. ...READ MORE

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

Is there a way to produce a sum according to date/time stamp values of another column on excel?

Assuming the input data for the second ...READ MORE

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

Python: How do I get multiple results in the same excel sheet?

Try this: fmin = lambda x: abs(x).min() fmax = ...READ MORE

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

How to do the comand IF THEN in Excel

Try this: =SUM(IF(AND(H39<=38,H39>=20),1,0),... If so then maybe this is ...READ MORE

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

TextEffect to TextFrame Adjustment (Mismatch)

Delete the original shape and then replace, ...READ MORE

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

How do ask ChatGPT with API from Excel macros (vba)?

A few things that will help. Don't ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 3,203 views
0 votes
1 answer

How do I obtain temporary AWS credentials for an unauthenticated role in PowerShell using a Cognito IdentityPool?

To obtain temporary AWS credentials for an ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 2,945 views
0 votes
1 answer

How do I stop python from appending data to the same row in excel?

There is no indication in your code ...READ MORE

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