Trending questions in Edureka Community

0 votes
1 answer

Mapping cells between between two ranges

Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE

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

Uipath(RPA) : read data from the PDF file and write to Excel file

is there any video recording to enable ...READ MORE

Jul 6, 2023 in Others by Santhosh
edited Mar 5 • 2,516 views
0 votes
1 answer

Nesting functions within the IF statement in EXCEL

For Excel 2019 and above use TEXTJOIN ...READ MORE

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

Add a correct format date in Excel file with Python openpyxl

Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 86,360 points • 3,247 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 • 144 views
0 votes
0 answers

How to remove [ and ] from the events with SEDCMD command in props.conf?

i used EDCMD-remove_brace = s/[// SEDCMD-remove_brace2 = ...READ MORE

Apr 19, 2023 in Linux Administration by anonymous
edited Mar 5 • 259 views
0 votes
1 answer

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

Yes, it is definitely possible to switch ...READ MORE

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

Is it possible to create a universal hyperlink in excel for windows and mac without programming

You may learn whether it runs on ...READ MORE

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

Create dropdown list in excel that displays different values from the same lookup table

Looks like the Worksheet_Change() sub needs two ...READ MORE

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

VBA - Applying border around the areas with value/text

Try this: Sub BorderArroudAreas() Dim sh ...READ MORE

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

Is it required for a QA tester to learn DevOps?

Yes, it is becoming increasingly important for ...READ MORE

Apr 11, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5 • 1,085 views
0 votes
0 answers

What is argument of type 'never[ ]' is not assignable to parameter of type 'string' in TypeScript

This is my code : export default class ...READ MORE

Apr 18, 2023 in TypeSript by anonymous
edited Mar 5 • 307 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT(- ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 879 views
0 votes
0 answers

I want to check package kexec in all server how do i do it

I want to check package kexec in ...READ MORE

Apr 19, 2023 in Ansible by anonymous
edited Mar 5 • 245 views
0 votes
1 answer

Excel Debt Payoff Calculator

You can change the formula in the ...READ MORE

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

Global Collections

To store your public objects and expose ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 998 views
0 votes
0 answers

AppSync DynamoDB atomic append to existing list attribute and other list operations

We have an object in dynamo DB ...READ MORE

Apr 21, 2022 in AWS by Soham
 • 9,730 points • 1,162 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 • 131 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 • 549 views
0 votes
1 answer

Field Wrong Calculations

You can accomplish your goals in one ...READ MORE

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

Excel VBA Selecting Multiple columns with last row and apply Condition Format

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

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

MS Excel Reordering letters in cell

Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE

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

How to create arrow buttons in Excel to scroll the table left and right?

Ctrl-shift-home goes to the upper-left of all ...READ MORE

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

Export Attachment from outlook to excel cells

You will need to save the attachment ...READ MORE

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

Loop through each cell in a given range and change the value depending on value in a column in the same row

Use match() and if() without code at ...READ MORE

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

Linking 3 Flutter Projects in One Flutter Project

Yes, it is possible to combine multiple ...READ MORE

Mar 20, 2023 in Flutter by vinayak
 • 1,516 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 • 855 views
0 votes
1 answer

Using Substitute or Replace to change specified characters to characters in another cell in a specific order Excel

Replace Occurrences of a Substring With a ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 855 views
0 votes
0 answers

Does Visual Studio Code support Environment Variables for the ChatGPT extension?

I would like to open the editor ...READ MORE

Apr 18, 2023 in ChatGPT by anonymous
 • 990 points
edited Mar 5 • 205 views
0 votes
1 answer

Why am I not being able to read the Excel sheet in my Jupyter Notebook

Verify that it is actually in your ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,098 views
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 • 920 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 • 153 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,710 points
edited Mar 5 • 120 views
0 votes
1 answer

What is Azure DevOps Boards?

Azure DevOps Boards is a project management ...READ MORE

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

File module issues with excel format

The xlsx extensions are not supported by ...READ MORE

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

What is the most effective way to make ChatGPT to resolve math problems?

What is the most effective prompt to ...READ MORE

Apr 18, 2023 in ChatGPT by anonymous
 • 990 points
edited Mar 5 • 172 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 • 119 views
0 votes
1 answer

Code breaks after executing copy statement in VBA?

Qualify the sheets with a workbook reference ...READ MORE

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

What exactly is Chef?

Although I'm not involved with DevOps or ...READ MORE

Apr 14, 2023 in DevOps & Agile by anonymous
edited Mar 5 • 826 views
0 votes
1 answer

Run macro when on Worksheet change (i.e. changing sheets, not data within sheet)

Try this: 'put this sub in ThisWorkbook module ...READ MORE

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

How do I adjust the size of the pasted image in Outlook email?

Try this : Option Explicit '~~> Since we are ...READ MORE

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

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

I think this might be more of ...READ MORE

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

How to specify `logs:CreateLogGroup` permission for AWS ECS Fargate container in CloudFormation YAML?

To specify the logs:CreateLogGroup permission for an ...READ MORE

Feb 17, 2023 in AWS by sarit
 • 1,830 points • 2,708 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,710 points
edited Mar 5 • 905 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 • 875 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Try this: let columnNames= {"E ...READ MORE

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