Trending questions in Edureka Community

0 votes
1 answer

Is there a way to remove password in a Excel file (.xls) using shell in Linux with known password?

Dig into the Excel documentation for the ...READ MORE

Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,612 views
0 votes
1 answer

How to merge columns in Excel but keep data on other columns

VLOOKUP indeed can be used here, combined ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 63,600 points
1,093 views
0 votes
0 answers

How can I install NebulaGraph databse on AWS without deploying the workbench?

I'm setting up a Nebula Graph cluster ...READ MORE

Dec 13, 2022 in AWS by Roshan
• 300 points

edited Mar 4 68 views
0 votes
1 answer

Configure Zabbix monitoring tool on kubernetes cluster in GCP

Zabbix is already set up with auto ...READ MORE

Nov 10, 2022 in GCP by Ashwini
• 5,430 points
1,448 views
0 votes
0 answers

FB Login not working with React Native iOS v13+

I've a project with following configuration. "react": "16.8.3", "react-native": ...READ MORE

Nov 10, 2022 in Mobile Development by gaurav
• 23,260 points
1,343 views
0 votes
1 answer

Import online excel file in google spreadsheet?

The function is: /** * Convert Excel file ...READ MORE

Nov 26, 2022 in Others by narikkadan
• 63,600 points
775 views
0 votes
0 answers

Convert async Task from c# to vb.net

I'm using a C# to VB.NET converter ...READ MORE

Dec 12, 2022 in C# by Roshan
• 300 points

edited Mar 4 106 views
0 votes
1 answer

Sending excel data to Tally

You can use Requests to send the ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 63,600 points
1,080 views
0 votes
1 answer

How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

Nov 26, 2022 in Others by narikkadan
• 63,600 points
774 views
0 votes
0 answers

How to install OpenROAD in AWS/Amazon Linux?

Let me clarify this. I am a ...READ MORE

Dec 13, 2022 in AWS by Roshan
• 300 points

edited Mar 4 57 views
0 votes
0 answers

Adding Images in Azure DevOps Wiki

Describe DevOps. I don't understand it, but ...READ MORE

Dec 13, 2022 in DevOps on Cloud by Nicholas
• 7,760 points

edited Mar 4 46 views
0 votes
0 answers

How to sign-in to EKS cluster without aws-auth configmap?

My aws-auth configmap contains the aws roles ...READ MORE

Dec 13, 2022 in AWS by Roshan
• 300 points

edited Mar 4 47 views
0 votes
0 answers

why this error ? ERROR Cannot add or update a child row a foreign key constraint fails

create table per( sl_no int UNIQUE NOT ...READ MORE

Dec 13, 2022 in Database by abc

edited Mar 4 54 views
0 votes
1 answer

Flutter different theme for Android and iOs

You can easily override theme by wrapping ...READ MORE

Nov 25, 2022 in Mobile Development by gaurav
• 23,260 points
851 views
0 votes
0 answers

Flutter different theme for Android and iOs

I want to use a different theme ...READ MORE

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

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

Nov 4, 2022 in Others by narikkadan
• 63,600 points
1,709 views
0 votes
1 answer

How can i add cells if condition is met

Both the AND function and nested if ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 63,600 points
841 views
0 votes
1 answer

How to change the project in GCP using CLI commands?

gcloud config set project $MY_PROJECT_ID #=> Updated property [core/project]. You ...READ MORE

Nov 4, 2022 in GCP by Tejashwini
• 3,820 points
1,707 views
0 votes
0 answers

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

How should the system lock screen be ...READ MORE

Nov 22, 2022 in Android by Edureka
• 12,690 points
878 views
0 votes
1 answer

How to create and download excel document using asp.net

First, download the Open XML Format SDK 2.0. It comes ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 63,600 points
3,106 views
0 votes
1 answer

How to display Toast in Android?

Use the show() function of the Toast ...READ MORE

Nov 8, 2022 in Android by Edureka
• 12,690 points
1,592 views
0 votes
0 answers

Running binary via node.js in EKS leads to permission denied error

The code functions well elsewhere and on ...READ MORE

Dec 13, 2022 in AWS by Roshan
• 300 points

edited Mar 4 24 views
0 votes
1 answer

How can I record a conversation / phone call on iOS?

This is for you. complete working illustration ...READ MORE

Nov 8, 2022 in IOS by Rahul
• 9,680 points
1,518 views
0 votes
0 answers

Create an Android GPS tracking application

I recently started learning Android coding as ...READ MORE

Nov 23, 2022 in Android by Ashwini
• 5,430 points
881 views
0 votes
0 answers

How to get first and last day of the current week in JavaScript

Today = new Date(); the object is ...READ MORE

Dec 12, 2022 in Java by Nicholas
• 7,760 points

edited Mar 4 49 views
0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

The maximum-open-cursors error, also known as ORA-01000, ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 63,600 points

edited Jul 5, 2023 by Khan Sarfaraz 4,018 views
0 votes
1 answer

Excel: Median of even number of values with a condition

The LARGE function, COUNT function, and TRUNC ...READ MORE

Nov 26, 2022 in Others by narikkadan
• 63,600 points
730 views
0 votes
1 answer

I have filtered my Excel data and now I want to number the rows. How do I do that?

Solution Filter your data. Select the cells you want ...READ MORE

Nov 14, 2022 in Others by narikkadan
• 63,600 points
1,250 views
0 votes
0 answers

Tamil content not found in excel

I downloaded an excel document in Tamil. ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,000 points
727 views
0 votes
1 answer

Programmatically register a broadcast receiver

This example shows how to programmatically register ...READ MORE

Nov 10, 2022 in Android by Edureka
• 12,690 points
1,387 views
0 votes
5 answers

How to resolve this error “Jenkins Host key verification failed”?

HI Mam, Please check the following solution:: 1. Switch ...READ MORE

May 3, 2019 in Jenkins by anonymous
62,954 views
0 votes
0 answers

Android Studio Auto Generated public final class R file

My project was operating normally until last ...READ MORE

Nov 16, 2022 in Android by Edureka
• 12,690 points
1,107 views
0 votes
0 answers

SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE

I'm trying to create a time clock ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,000 points
4,580 views
0 votes
0 answers

How to fetch the width and height of a programatically added view in Swift/ iOS?

I have added a UIView and a ...READ MORE

Nov 10, 2022 in Mobile Development by gaurav
• 23,260 points
1,269 views
0 votes
0 answers
0 votes
1 answer

Countifs formula using weekday function

Use SUMPRODUCT: =SUMPRODUCT(((WEEKDAY(TODAY())>= 3)*(WEEKDAY(TODAY())<=6)*(INT(AG10:AG100)=INT(TODAY()-1)))+((WEEKDAY(TODAY())=2)*(INT(AG10:AG100)>=INT(TODAY()-3))*(INT(AG10:AG100)<=INT(TODAY()-1)))) If the Dates in AG ...READ MORE

Nov 26, 2022 in Others by narikkadan
• 63,600 points
708 views
0 votes
0 answers

Best way to find if an item is in a JavaScript array?

What is the best approach to determine whether an object is in an array? This is the best method I've found: function include(arr, obj) { for (var ...READ MORE

Dec 12, 2022 in Java by Nicholas
• 7,760 points

edited Mar 4 24 views
0 votes
1 answer

Writing data to google cloud storage using python

Using the Python library for Google Cloud ...READ MORE

Nov 8, 2022 in GCP by Ashwini
• 5,430 points
1,483 views
0 votes
1 answer

When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

I see you asked it a long ...READ MORE

Nov 7, 2022 in Others by gaurav
• 23,260 points
1,556 views
0 votes
1 answer

Generate VCards from Excel using VBA

Solution  Create a class called CContact with getters ...READ MORE

Nov 21, 2022 in Others by narikkadan
• 63,600 points
881 views
0 votes
1 answer

Prompt message if Excel column has some value in asp.net c#

I believe it is wise to use ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 63,600 points
785 views
0 votes
0 answers

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

I have open the Google Play store ...READ MORE

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

How to clear contents of an Excel Workbook through vba

When the range you're referring to doesn't ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 63,600 points
998 views
0 votes
1 answer

Unrecognized SSL message, plaintext connection? Exception

It is due to the fact that ...READ MORE

Feb 22, 2022 in Java by Aditya
• 7,680 points
12,635 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

Nov 17, 2022 in Others by narikkadan
• 63,600 points
1,045 views
0 votes
1 answer

Hosting Microsoft Edge via WebView2Loader.dll with Excel VBA

Here's an API to communicate with Chromium ...READ MORE

Sep 29, 2022 in Others by narikkadan
• 63,600 points
3,241 views
0 votes
0 answers

How to Calculate Height of Android Phone from ground?

In order to complete a project, I ...READ MORE

Nov 24, 2022 in Android by Tejashwini
• 3,820 points
670 views
0 votes
1 answer

Excel dropdown with name/value pairs

Solution Define a range to use as the ...READ MORE

Oct 7, 2022 in Others by narikkadan
• 63,600 points
2,846 views
0 votes
0 answers

Excel: How to Sort or filter text by specific word or words?

Even if the term is used in ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,000 points
681 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

Nov 21, 2022 in Others by narikkadan
• 63,600 points
862 views