Trending questions in Edureka Community

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 • 724 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 • 2,879 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 • 411 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
 • 63,600 points • 449 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 • 705 views
0 votes
0 answers

Can I run Cloud Automation (azure or aws) for web apps in background and performing other tasks on same device?

Hi all, my goal is to automate some ...READ MORE

Apr 14, 2023 in Software Testing by Antonina
edited 4 days ago • 108 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 3 days ago • 611 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 • 599 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
 • 63,600 points • 549 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 4 days ago • 88 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 • 502 views
0 votes
1 answer

Combine Two Formulas in Separate Cells Into One Cell

Use the openpyxl module in Python to do that, ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 882 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,690 points
edited 3 days ago • 693 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
 • 63,600 points • 707 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,020 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
 • 63,600 points • 1,622 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 • 639 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 • 464 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,173 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
 • 63,600 points • 789 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
 • 63,600 points • 657 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
 • 63,600 points • 656 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 • 916 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 • 8,756 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 • 610 views
0 votes
1 answer

Macro VBA code failing to execute a section of the code without an error

You get your code to make a ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 909 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 4 days ago • 100 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
 • 63,600 points • 859 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,027 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
 • 63,600 points • 464 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
 • 63,600 points • 630 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
 • 63,600 points • 544 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 • 716 views
0 votes
1 answer

Flutter scrollable positioned list support rtl text direction?

To support RTL text direction in the ...READ MORE

Mar 18, 2023 in Android by vishalini
 • 1,208 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 • 711 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
 • 1,855 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 • 706 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 • 484 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 • 571 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 • 700 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 • 565 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 4 days ago • 12 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,081 views
0 votes
0 answers

Azure DevOps configuration with Jenkins

Can anyone help me how I can ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,690 points
edited 4 days ago • 14 views
0 votes
0 answers

How swap slots in azure devops

I have two slots present in my ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited 4 days ago • 13 views
0 votes
0 answers

GitLab CI/CD: How do I generate a change log between pipeline runs?

I'm currently using Gitlab CI/CD combined with ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited 4 days ago • 8 views
0 votes
0 answers

Is it required for a QA tester to learn DevOps?

Is it necessary for a QA tester ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,690 points
edited 4 days ago • 13 views
0 votes
0 answers

I want to switch my career from QA tester to DevOps. Is it good? What are the courses that I can take for DevOps?

Is it good to switch my career ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 12,690 points
edited 4 days ago • 13 views
0 votes
0 answers

docker prune all images but keep images downloaded or created less than 48 hours ago?

Problem we're trying to overcome: We'd like ...READ MORE

Apr 13, 2023 in DevOps & Agile by anish
 • 400 points
edited 4 days ago • 12 views
0 votes
0 answers

What are the different job roles one can apply by doing DevOps course?

What are the various job roles one ...READ MORE

Apr 13, 2023 in DevOps & Agile by Edureka
 • 13,620 points
edited 4 days ago • 13 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.