Trending questions in Edureka Community

0 votes
0 answers

how to count the number of methods other than OPTION on AWS API Gateway with python?

I need to count the number of ...READ MORE

Feb 14, 2023 in AWS by Ashwini
 • 5,430 points • 1,080 views
0 votes
1 answer

Why the data type in last columns is str instead of float?

Have you attempted to float-ify that column ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 86,360 points • 1,172 views
0 votes
1 answer

Sublist on Excel

Try using this formula in sheet 1  =FILTER(Sheet2!B3:B8,Sheet2!E3:E8<2) The ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 811 views
0 votes
1 answer

Copying and pasting from one workbook to another doesn't work

Your ranges aren't fully qualified. Excel will make ...READ MORE

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

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 86,360 points • 7,776 views
0 votes
0 answers

How to open WhatsApp using an Intent in your Android App?

I want an Intent to take control ...READ MORE

Nov 23, 2022 in Android by Ashwini
 • 5,430 points • 4,706 views
0 votes
1 answer

Do Until replay tree times

Clean Data: Apply Consistent Formatting in Columns Option ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 86,360 points • 1,137 views
0 votes
0 answers

What are the requirements to become AWS DevOps Engineer?

Could someone please let me know what ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
 • 13,750 points • 1,071 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
 • 86,360 points • 7,811 views
0 votes
1 answer

Index and Match multiple matches

You can try the following (formula 1) ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 1,262 views
0 votes
0 answers

In which language is basically written Chrome Browser on Android?

What language is the Android version of ...READ MORE

Nov 10, 2022 in Android by Edureka
 • 13,750 points • 1,542 views
0 votes
1 answer

Put text body above the pasted range

Set x before you paste. x = doc.Range.End ...READ MORE

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

Highlight closest cell value in a table

Conditional formatting will be used to highlight ...READ MORE

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

How to get all Stock list company name and symbol of NSE and BSE with free API?

Check the below link for your answer: http://www.barchartondemand. ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 5,102 views
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
 • 86,360 points • 1,424 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
 • 86,360 points • 1,983 views
0 votes
1 answer

Open webpage in fullscreen in Safari on iOS

No, javascript cannot be used to switch ...READ MORE

Nov 4, 2022 in IOS by Rahul
 • 9,690 points • 5,481 views
0 votes
1 answer

How to increment a column value if it repeats, otherwise reset to 1?

Use COUNTIF: =COUNTIF(A$2:A2,A2) The absolute and relative cell coordinates ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,500 views
0 votes
1 answer

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 3,659 views
0 votes
1 answer

Appreciate any suggestion

You could try and add a feature ...READ MORE

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

How to query a matrix for multiple values and receive value

Try: =IFERROR(INDEX(SORT(SORT(FILTER(MATRIX, (LENGTHS>length)*(WEIGHTS>weight)),1,1),2,1),1,3),1) , where MATRIX, LENGTHS, and WEIGHTS ...READ MORE

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

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I experimented with the following code in ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 8,639 views
0 votes
0 answers

HOW TO GET A SPECIFIC CELL TO CHOOSE BETWEEN 5 FIXED CELLS BASED ON 01 VARIABLE CELL?

C3 gets a value from another Tab ...READ MORE

Mar 3, 2023 in Others by Sean
edited Mar 5 • 338 views
0 votes
1 answer

How do I copy a specific range of cells after I use AutoFilter in VBA?

Set the range of filtered data Set Rng ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 1,564 views
0 votes
1 answer

Searching Multiple Criteria In Large Data Set to make new Data Set Excel VBA

Copy the data to an array, filter ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 1,654 views
0 votes
1 answer

Excel VBA - Out of memory when create a dynamic array formula

Try this: Sub MyArray() Range("A1").Formula2 = "=R[2]C[2]:R[2]C[6]" End Sub But that ...READ MORE

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

How to paste an Excel chart into PowerPoint placeholder using Python?

Very near indeed! Copy and Paste are ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 6,652 views
0 votes
1 answer

I need help connecting my python file to excel to execute the output of my program to excel

you can replace concat with append and its will work but ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,465 views
0 votes
1 answer

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,465 views
0 votes
1 answer

Hide or visible sheets

Use a loop instead of repeating very similar ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 1,205 views
0 votes
0 answers

Azure KeyVault and Authentication on client side

I'd like to know more about the ...READ MORE

Feb 15, 2023 in Azure by Damonlang
 • 1,230 points • 997 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 4,875 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
 • 86,360 points • 2,447 views
0 votes
1 answer

Having trouble hiding activecell column across tabs using vba

You might keep track of the location ...READ MORE

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

To Keep only 1 header while merging Multiple file

There is potential for improvement here, such ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 1,621 views
0 votes
1 answer

How can I automatically formulate a column while adding values ​to another? EXCEL

Use a # in your range references ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 895 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,580 points • 5,320 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

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

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

What do CI tools enable DevOps engineers to do?

Can anyone tell me what do CI ...READ MORE

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

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 5,873 views
0 votes
0 answers

Termux code to install git on termux in Android mobile

$ pkg install github Says: Reading state information... Done E: ...READ MORE

Nov 8, 2022 in Android by Edureka
 • 13,750 points • 2,542 views
0 votes
1 answer

Excel Formula Extract any number greater than x charters from a string

Given that you employ two separate delimiters, ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 891 views
0 votes
0 answers

How can I delete a value from a list in another a list?

I have created a list with three ...READ MORE

Mar 2, 2023 in Python by anonymous
edited Mar 5 • 304 views
+2 votes
1 answer

How to implement the system lock screen in your own android app?

There is a feature in Android called ...READ MORE

Nov 23, 2022 in Android by Edureka
 • 13,750 points
edited Mar 5 • 4,470 views
0 votes
0 answers

I want to build open source billing system for Open Stack with easy deploy.

I want to build open source billing ...READ MORE

Feb 15, 2023 in OpenStack by Sumon
edited Mar 4 • 939 views
0 votes
0 answers

What are the prerequisites for AWS Certified DevOps Engineer Professional certification?

Could someone please let me know what ...READ MORE

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

Bloomberg excel add-in BDH

Change an override Fill=P to, for instance, ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 86,360 points • 6,406 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 86,360 points • 7,626 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.