Trending questions in Edureka Community

0 votes
1 answer

VBA Regular Expression to return ALL matching patterns

You have set the global to false, ...READ MORE

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

Conditional Formatting not applying to all the cells in a given range

Use the following instead as the Formula: =$P5=75% I ...READ MORE

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

Excel - FIND function (case-sensitive) ignores case?

Just to show the behaviour of find(): READ MORE

Apr 3, 2023 in Others by narikkadan
 • 63,600 points • 897 views
0 votes
1 answer

Error Trying to Display The Names of All Excel Data Models in a Workbook

It is necessary to list ThisWorkbook.model. Not ...READ MORE

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

Can't able fetch data form json using class in flutter(dart)

To fix the issue of null temperature ...READ MORE

Mar 18, 2023 in Android by vinayak
 • 1,622 views
0 votes
1 answer

Open Existing PowerPoint via VBA

You do not have the proper reference ...READ MORE

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

An error occurred (InvalidClientTokenId) when calling the GetCallerIdentity operation: The security token included in the request is invalid.

Hi@akhtar, I think there is a problem with ...READ MORE

Sep 23, 2020 in AWS by MD
 • 95,460 points • 40,687 views
0 votes
1 answer

Comparing worksheets from a directory of xlsx files

Here is a refactored version of your ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 63,600 points • 721 views
0 votes
1 answer

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,192 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
 • 63,600 points • 718 views
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
 • 63,600 points • 1,149 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 • 143 views
0 votes
1 answer

Move multiple Azure Devops projects into one project same org

Yes, it is possible to move all ...READ MORE

Apr 11, 2023 in DevOps & Agile by anonymous
 • 12,690 points
edited Mar 5 • 980 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 • 55 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
 • 63,600 points • 684 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 • 143 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,071 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,355 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 • 188 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 • 454 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
 • 63,600 points • 531 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 • 744 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 • 917 views
0 votes
1 answer

Global Collections

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

Apr 1, 2023 in Others by narikkadan
 • 63,600 points • 873 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,690 points
edited Mar 5 • 75 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,690 points
edited Mar 5 • 928 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,710 points • 1,023 views
0 votes
1 answer

Openpyxl password protect excel file python

Workbooks can be secured against certain actions, ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 9,039 views
0 votes
1 answer

How to do Rounded Corners Image in Flutter?

To make the image in your Flutter ...READ MORE

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

Field Wrong Calculations

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

Apr 3, 2023 in Others by narikkadan
 • 63,600 points • 757 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
 • 63,600 points • 749 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 • 66 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
 • 63,600 points • 744 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
 • 63,600 points • 826 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,690 points
edited Mar 5 • 29 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Your table dbo.Sup Item Cat refers to ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 9,224 views
0 votes
1 answer

TypeError: $(...).DataTable is not a function

This happened because the jQuery DataTables library ...READ MORE

Apr 30, 2022 in Git & GitHub by narikkadan
 • 63,600 points • 15,352 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,297 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,690 points
edited Mar 5 • 26 views
0 votes
1 answer

Conversion failed when converting date and/or time from character string while inserting datetime

The SQL server supports many formats. Most ...READ MORE

Apr 30, 2022 in Other DevOps Questions by narikkadan
 • 63,600 points • 15,352 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,076 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 • 550 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
 • 63,600 points • 719 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
 • 63,600 points • 3,001 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 • 30 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,050 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,690 points
edited Mar 5 • 861 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 • 64 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 • 726 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.