Trending questions in Edureka Community

0 votes
1 answer

How do I output the row containing the lowest value from a specific column inside a filtered dynamic array?

Instead of using 1 filter function to ...READ MORE

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

Application.Workbooks(V_WBNameOutPut).Activate alternative

You can capture the workbook when it's ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,600 points • 330 views
0 votes
0 answers

DevOps Engineer Roles And Responsibilities

What are the various duties of an ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
 • 12,690 points • 517 views
0 votes
0 answers

Can I apply Slicer value to Summarize function

Hello, I have a Table called work program ...READ MORE

Feb 26, 2023 in Power BI by rajkumar
edited 6 days ago • 8 views
0 votes
0 answers

How to create scatter plot in Tableau from database format?

How to create scatter plot in Tableau ...READ MORE

Feb 23, 2023 in Tableau by Tivadar
edited 6 days ago • 95 views
0 votes
0 answers

What should be the career objective for DevOps Engineer?

Could someone please tell me what a ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
 • 12,690 points • 493 views
0 votes
1 answer

How to read A column in xlsx file with pandas?

You can view all the columns with: excel_data.head() ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,600 points • 669 views
0 votes
1 answer

Reshape excel table with stacked date column

I agree that using a pivot makes ...READ MORE

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

VBA Create and Rename Tables

Convert Table to Excel Table (ListObject) Option Explicit Sub ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 63,600 points • 1,351 views
0 votes
1 answer

How can I rename each column of a table?

Add Name For Each Column Sub AddNames() ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 63,600 points • 745 views
0 votes
1 answer

Macro /excel date format change

You must handle the string Date differently ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 439 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,600 points • 1,733 views
0 votes
1 answer

Conditional formatting with Index(Match), 2 conditions (vertical & horizontal)

Use FILTER to search using two or ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,600 points • 1,084 views
0 votes
1 answer

Copy the respective values from another workbook depend on specific conditions

Try this: Sub Get_Respective_Values_Of_Last_Closing_Date() Dim wb1 ...READ MORE

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

Excel Visual Basic managing coordinate tuple type

A tuple can be saved as an ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 63,600 points • 861 views
0 votes
0 answers

Do DevOps engineers write code?

Can anyone tell me whether coding is ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
 • 13,620 points • 409 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 601 views
0 votes
1 answer

Excel to Word Macro resulting in Run-time error 462

Are you attempting this (UNTESTED)? I've commented ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,600 points • 1,116 views
0 votes
1 answer

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 5,569 views
0 votes
0 answers

int number = 64; char special = (char) number; System.out.println(special);

int number = 64; char special = (char) ...READ MORE

Feb 24, 2023 in Java by Asande
edited 6 days ago • 7 views
0 votes
1 answer

Is there any built-in factorial function in c++?

Although no C function is written particularly for computing factorials, the C math package allows you to compute the gamma function. Because (n) Equals (n-1)!  Using tgamma of i+1 on positive integers returns i!. for (int i = 1 ; ...READ MORE

Aug 2, 2022 in C++ by Damon
 • 4,960 points • 8,887 views
0 votes
1 answer

Sort numeric values VBA

Try: The formula in B1: =SORTBY(A1:A8,LEFT(A1:A8&"0000 ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 548 views
0 votes
0 answers

What is the work of devops engineer?

Could you please explain the role of ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
 • 12,690 points • 436 views
0 votes
1 answer

Setting mime type for excel document

I assume application/vnd.ms-excel is the standard MIME ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 14,108 views
0 votes
0 answers

Dump DDL for EXTERNAL FILE FORMAT - Azure SQL DW

If one had used CREATE EXTERNAL FILE FORMAT ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 419 views
0 votes
0 answers

Create Terraform Cloudwatch Dashboards dynamically

Overview Currently, dashboards are being deployed via Terraform ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
 • 3,820 points • 858 views
0 votes
1 answer

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Use  SHFileOperation API Option Explicit Private Declare PtrSafe Function SHFileOperation ...READ MORE

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

Export ListBox Data to Sheet range

Use ListCount to retrieve the number of ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,600 points • 1,817 views
0 votes
0 answers

Related to jar files

: Unable to access jarfile consent-giver-api-0.1-SNAPSHOT.jar READ MORE

Feb 23, 2023 in Java by Humera
edited 6 days ago • 15 views
0 votes
1 answer

Fixed position but relative to container

The issue with "fixed" positioning is that ...READ MORE

Jun 28, 2022 in CSS by Edureka
 • 12,690 points • 10,336 views
0 votes
1 answer

Excel: Count distinct numerical values if string condition matches

FILTER Shipper and Month based on Employee ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 552 views
0 votes
0 answers

related to jar files

Unable to initialize main class com.tectoro.codocs.ca.Application Caused by: ...READ MORE

Feb 23, 2023 in Java by Humera
edited 6 days ago • 8 views
0 votes
1 answer

Ordering data in python or excel

Basically, the data is converted from wide ...READ MORE

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

How to remove borders from cells in a range in Excel using VB.net?

range.Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeRight).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeBottom).LineStyle ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 2,100 views
0 votes
1 answer

SQL WHERE ID IN (id1, id2, ..., idn)

Option 1 is the only good solution. Why? Option ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,600 points • 7,085 views
0 votes
1 answer

Having issues with pop-up alert in excel. (Visual Basic)

You may find the following code of ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 63,600 points • 795 views
0 votes
1 answer

Is there an efficient way to do this excel function

Use vlookup(): VLOOKUP(E2,$B$4:$C$8,2,1) READ MORE

Feb 7, 2023 in Others by narikkadan
 • 63,600 points • 667 views
0 votes
1 answer

How to open the Google Play Store directly from my Android application?

If you want to link to your ...READ MORE

Nov 7, 2022 in Android by Edureka
 • 12,690 points • 4,699 views
0 votes
1 answer

Is there a faster way to delete table rows so my script doesn't take hours to run?

This is for your rowAddressToRemove variable. So instead of ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 63,600 points • 964 views
0 votes
1 answer

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 63,600 points • 789 views
0 votes
1 answer

Hide contents of drop-down list in Excel with password?

So, 3 versions all relatively similar: Above shown ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 63,600 points • 828 views
0 votes
0 answers

Insert an item into sorted list in Python

I'm creating a class where one of ...READ MORE

Feb 22, 2023 in Python by Arya
 • 990 points
edited 6 days ago • 17 views
0 votes
0 answers

How to access the GCS Bucket object through my application without public access?

I would like to connect GCS object ...READ MORE

Feb 20, 2023 in DevOps on Cloud by Pradeep
edited 6 days ago • 113 views
0 votes
0 answers

Determining whether an value is a whole number in Python

I would like to determine if a ...READ MORE

Feb 22, 2023 in Python by Arya
 • 990 points
edited 6 days ago • 13 views
0 votes
1 answer

Asset Write off calculation Automation

How about this in O29: =LET(period, ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 346 views
0 votes
0 answers

How can I implement a tree in Python?

How can I implement a general tree ...READ MORE

Feb 22, 2023 in Python by Arya
 • 990 points
edited 6 days ago • 9 views
0 votes
0 answers

Convert string / character to integer in python

I want to convert a single character ...READ MORE

Feb 22, 2023 in Python by Arya
 • 990 points
edited 6 days ago • 9 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,600 points • 2,636 views
0 votes
1 answer

How to pass parameters in GET requests with jQuery?

Hello, Here is the syntax using jQuery $.get $.get(url, data, ...READ MORE

Apr 28, 2020 in JQuery by Niroj
 • 82,840 points • 44,452 views
0 votes
1 answer

Find max and second max salary for a employee table MySQL

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,260 points • 4,649 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.