Latest questions in Edureka Community

0 votes
0 answers

Conditional statement (truth table) formula on Excel

What is the formula for p=>q? READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
38 views
0 votes
0 answers

How to reduce a huge excel file

I have a short, straightforward *.XLS file ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
25 views
0 votes
0 answers

VBA SQL Connection to Excel from Word returns no records

Trying to figure out how to read ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
37 views
0 votes
0 answers
0 votes
0 answers

How to apply Filter and and copy filter results to another sheet using C# and Excel Interop

I want to apply a filter to ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
36 views
0 votes
0 answers

Combining MID and LEFT Functions in Excel 2019

I currently have a course name and ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
21 views
0 votes
0 answers

Tamil content not found in excel

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

Nov 27 in Others by Kithuzzz
• 20,660 points
18 views
0 votes
0 answers

Excel VBA: How to change order of scenarios

I'm trying to run a VBA loop ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
19 views
0 votes
0 answers

Strikethrough in Excel VBA

When I enter the second date in ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
25 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 in Others by Kithuzzz
• 20,660 points
21 views
0 votes
1 answer

Import online excel file in google spreadsheet?

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

Nov 26 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

How to convert an excel formula to SQL to calculate daily compound interest

Here is a solution that is effective. ...READ MORE

Nov 26 in Others by narikkadan
• 37,660 points
31 views
0 votes
1 answer

Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

By right-clicking the Retirement Planner sheet tab ...READ MORE

Nov 26 in Others by narikkadan
• 37,660 points
23 views
0 votes
1 answer

How to change compound annual growth rate (CAGR) formula depending on data existing/not existing?

Sep to calculate CAGR. Excel has an ...READ MORE

Nov 26 in Others by narikkadan
• 37,660 points
28 views
0 votes
1 answer

How to fix corrupted imported online excel in google sheet?

Issue and workaround: In the built-in functions for ...READ MORE

Nov 26 in Others by narikkadan
• 37,660 points
28 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 in Others by narikkadan
• 37,660 points
26 views
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

Nov 26 in Others by narikkadan
• 37,660 points
30 views
0 votes
1 answer

What does the " @ " symbol mean in Excel formula (outside a table)

Excel has recently introduced a huge feature ...READ MORE

Nov 26 in Others by narikkadan
• 37,660 points
22 views
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 in Others by narikkadan
• 37,660 points
19 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 in Others by narikkadan
• 37,660 points
23 views
0 votes
0 answers

Find nearest gas station using google maps v2 in android and want to display the route to it

The following code will help me locate ...READ MORE

Nov 25 in Android by Edureka
• 12,390 points
19 views
0 votes
0 answers

how to add vibration and ringtone when launch application home page android?

I want to add vibration and music ...READ MORE

Nov 25 in Android by Edureka
• 12,390 points
12 views
0 votes
0 answers

What is audio focus in Android class AudioManager?

There are two methods in the AudioManager ...READ MORE

Nov 25 in Android by Edureka
• 12,390 points
15 views
0 votes
0 answers

Android Phone Ip webcam app doesn't work with openCV in java

I attempted to connect using the IP ...READ MORE

Nov 25 in Android by Edureka
• 12,390 points
14 views
0 votes
0 answers

App is misconfigured for Facebook login: Android Facebook integration issue

I've linked Facebook with my app, and ...READ MORE

Nov 25 in Android by Edureka
• 12,390 points
14 views
0 votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
31 views
0 votes
1 answer

Loop formula in excel vba

You can use an IF statement to ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
33 views
0 votes
1 answer

Excel graphics with ggplot2

Excel's pseudo-3D charts are choked full of ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
23 views
0 votes
1 answer

Spire When Pdf-ing an excel file it leaves some formulas as System.Object[][]

Since you tested the Excel file and ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
42 views
0 votes
1 answer

How do I transpose a column to a matrix in Excel?

With data in column A, pick some cells ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

PHPExcel generated excel file not auto-calculating formula

By recalculating on the server side, it ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

Concatenate columns using LEFT and RIGHT in EXCEL

It's conceivable that the Concat/Concatenate function isn't ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
21 views
0 votes
1 answer

Parsing from Excel multisheet file: List comprehension between columns

You can use read_excel with parameter sheetname=None for return all sheets ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

Nov 25 in Others by narikkadan
• 37,660 points
25 views
0 votes
0 answers

How can I find the first occurrence of a sub-string in a python string?

I'd like to locate the first index ...READ MORE

Nov 24 in Python by sarit
• 300 points
57 views
0 votes
0 answers

How to check whether a variable is a class or not?

I was wondering how to check whether ...READ MORE

Nov 24 in Python by sarit
• 300 points
50 views
0 votes
0 answers

Repeating triangle pattern in Python

Depending on the integer input, I need ...READ MORE

Nov 24 in Python by sarit
• 300 points
34 views
0 votes
0 answers

Is it possible to get a list of keywords in Python?

I want to obtain a string list ...READ MORE

Nov 24 in Python by sarit
• 300 points
33 views
0 votes
0 answers

'for' loop in one line in Python

When I tried to use a for statement in ...READ MORE

Nov 24 in Python by sarit
• 300 points
23 views
0 votes
0 answers

Where is com.google.android.mms.*?

I'm writing an Android app that will ...READ MORE

Nov 24 in Android by Tejashwini
• 2,860 points
20 views
0 votes
0 answers

Failed to load map. Error contacting Google servers issue with android google maps api v2

For the past two days, I have ...READ MORE

Nov 24 in Android by Tejashwini
• 2,860 points
47 views
0 votes
0 answers

How to make gradient background in android

As in the example below, I want ...READ MORE

Nov 24 in Android by Tejashwini
• 2,860 points
24 views
0 votes
0 answers

Number of Downloads in Google Play

For a few months now, I've had ...READ MORE

Nov 24 in Android by Tejashwini
• 2,860 points
23 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 in Android by Tejashwini
• 2,860 points
19 views
0 votes
1 answer

VBA to protect and unprotect in given range in sheet

It needs a minor tweak to become ...READ MORE

Nov 24 in Others by Kithuzzz
• 20,660 points
38 views
0 votes
1 answer

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

Nov 24 in Others by narikkadan
• 37,660 points
36 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 in Others by narikkadan
• 37,660 points
31 views
0 votes
1 answer

How to look in all folders in directory to change file extensions of excel file?

Loop Through All Subfolders Using VBA Dim strCurrentFileExt ...READ MORE

Nov 24 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

PHPExcel file cannot open file because the file format or file extension is not valid

Just change the code to this: // Save Excel ...READ MORE

Nov 24 in Others by narikkadan
• 37,660 points
92 views