Trending questions in Edureka Community

0 votes
1 answer

VBA Code to Populate Balance Sheet from Trial Balance Data

It appears that what you need to ...READ MORE

Sep 24, 2022 in Others by narikkadan
• 86,360 points
1,962 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

The table name, column names, datatype, and ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
2,735 views
0 votes
1 answer

React Native and iOS share button

In this article, we will be learning ...READ MORE

Nov 4, 2022 in Others by gaurav
• 23,580 points
1,072 views
0 votes
1 answer

I have a problem with counta function in VBA

When the worksheet name has a space, ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
1,565 views
0 votes
1 answer

Extract unique value from the range in Excel

The portability of spreadsheet functions like UNIQUE() ...READ MORE

Sep 23, 2022 in Others by narikkadan
• 86,360 points
1,989 views
0 votes
1 answer

Excel use SUMIF but with a multiplier before summation: x2, x3, x4, etc

The product of the sum and the ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 86,360 points
1,687 views
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

Sep 26, 2022 in Others by narikkadan
• 86,360 points
1,859 views
0 votes
0 answers
0 votes
1 answer

what font face of clock on lock screen of iPhone (iOS 9)?

San Francisco is the default font in ...READ MORE

Sep 20, 2022 in IOS by Aditya
• 7,680 points
2,073 views
0 votes
1 answer

How can I keep my sub-menu open in jQuery hover menu?

keeping sub menu open on hover and ...READ MORE

Aug 2, 2022 in Web Development by rajatha
• 7,680 points
4,190 views
0 votes
0 answers

Can i create Data cube in power BI ? I f Yes then let me know How?

Can i create Data cube in power ...READ MORE

Nov 3, 2022 in Power BI by Rajesh

edited Mar 4 207 views
0 votes
1 answer

Is there a way to make HTML5 video fullscreen?

Although the Fullscreen API defines an API ...READ MORE

Aug 8, 2022 in HTML by Vikas
3,978 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

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

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

Oct 17, 2022 in Others by narikkadan
• 86,360 points
912 views
0 votes
1 answer

Is there a way to generate high resolution PNGs of iOS emoji?

Step 1: Visit Google Play Store on ...READ MORE

Nov 4, 2022 in Others by gaurav
• 23,580 points
1,036 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 86,360 points
1,659 views
0 votes
1 answer

How to define excel SUMIFS criteria considering any text and numbers?

It essentially ignores column C's missing entry ...READ MORE

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

How do I obtain a Query Execution Plan in SQL Server?

There are several ways to get an ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 86,360 points
2,083 views
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

select A1:J1 in worksheet B and enter: =TRANSPOSE('worksheet ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 86,360 points
1,859 views
0 votes
1 answer

Git error: "Please make sure you have the correct access rights and the repository exists"

Your git URL might have changed. Change ...READ MORE

Feb 17, 2022 in Others by Aditya
• 7,680 points
11,310 views
0 votes
0 answers

Reading call history in iPhone OS

As I look into the viability of ...READ MORE

Nov 3, 2022 in IOS by Soham
• 9,730 points

edited Mar 4 154 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
1,502 views
0 votes
1 answer

How to compile executable for Windows with GCC with Linux Subsystem?

Linux Subsystem fills in as a Linux-PC. ...READ MORE

Jun 20, 2022 in Linux Administration by Rahul
• 3,380 points
5,991 views
0 votes
0 answers

JSONDecodeError: Expecting value: line 1 column 1 (char 0)

I am facing an error when decoding ...READ MORE

May 9, 2022 in Python by Kichu
• 19,040 points
7,824 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Use a simple-ish median calculation for a ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 86,360 points
2,096 views
0 votes
1 answer

Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE

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

Is there a way to SUMIFS with multiple criteria + true or false?

You can add this as the  last criteria: =SUMIFS(STORE!$C$6:$C$1000;STORE!$A$6:$A$1000;""&SUMMARY!$D$5&"";STORE!$D$6:$D$1000;""&SUMMARY!$C$9&"";STORE!$E$6:$E$1000;""&SUMMARY!D8&"";STORE!$AA$6:$AA$1000;TRUE) STORE!$AA$6:$AA$1000: ...READ MORE

Oct 1, 2022 in Others by narikkadan
• 86,360 points
1,569 views
0 votes
0 answers

Drop multiple tables in one shot in MySQL

How to drop multiple tables from one ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
• 38,000 points
3,642 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

Sep 26, 2022 in Others by narikkadan
• 86,360 points
1,781 views
0 votes
1 answer

Authenticate to Google Drive and download spreadsheet with Python urllib2/requests

Your goal may be feasible, but the ...READ MORE

Sep 27, 2022 in Others by narikkadan
• 86,360 points
1,738 views
0 votes
1 answer

Excel Tax Calculator

You can replace it with a set ...READ MORE

Oct 15, 2022 in Others by narikkadan
• 86,360 points
930 views
0 votes
1 answer

In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

Oct 9, 2022 in Others by narikkadan
• 86,360 points
1,189 views
0 votes
1 answer

Java Apache POI Excel save as PDF

For the software to run, you'll need ...READ MORE

Mar 31, 2022 in Database by gaurav
• 23,580 points
9,481 views
0 votes
0 answers

how can i check the existance of new file in a ftp server every given period ?

I have to download a file from ...READ MORE

Oct 31, 2022 in Others by Imene

edited Mar 4 233 views
0 votes
0 answers

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

This is the exception on getConnection(): java.sql.SQLException: Access denied ...READ MORE

May 16, 2022 in Java by Kichu
• 19,040 points
7,516 views
0 votes
1 answer

Show tick symbol on label

Try this code: LblTick.Text = ((char)0x221A).ToString(); Easier method: lblTick.Text ...READ MORE

Oct 16, 2022 in Others by narikkadan
• 86,360 points
874 views
0 votes
0 answers

Hide text using css

I have a tag in my HTML ...READ MORE

Jul 29, 2022 in CSS by Edureka
• 13,730 points
1,772 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

Oct 9, 2022 in Others by narikkadan
• 86,360 points
1,175 views
0 votes
0 answers

NullPointerException: Attempt to invoke virtual method 'int java.util.ArrayList.size()' on a null object reference

I'm a newbie to Fragments and custom ListView adapters. Can anyone ...READ MORE

Sep 20, 2022 in Java-Script by Tejashwini
• 780 points
2,006 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

Sep 21, 2022 in Others by narikkadan
• 86,360 points
1,952 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,580 points
9,711 views
0 votes
1 answer

How Can I Round Prices to the nearest 0.95 with an Excel Formula?

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

Oct 9, 2022 in Others by narikkadan
• 86,360 points
1,154 views
0 votes
0 answers

How can I permanently delete my account?

I want to delete my account, and ...READ MORE

Oct 30, 2022 in Ask us Anything! by anonymous

edited Mar 4 250 views
0 votes
1 answer

iOS Post to Facebook shows m.facebook.com

From your Feed, tap Search Facebook at ...READ MORE

Nov 4, 2022 in Others by gaurav
• 23,580 points
930 views
0 votes
1 answer

Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 86,360 points
1,424 views
0 votes
1 answer

iPhone system font

The iPhone system interface uses Helvetica or ...READ MORE

Sep 20, 2022 in Others by Aditya
• 7,680 points
1,959 views
0 votes
1 answer

How to convert PDF to Excel in C#?

Solutions a) xodo makes a free online conversion from PDF ...READ MORE

Oct 1, 2022 in Others by narikkadan
• 86,360 points
1,507 views
0 votes
0 answers

PHP - Failed to open stream : No such file or directory

In PHP scripts, when I call include(), require(), fopen(), or ...READ MORE

May 16, 2022 in PHP by Kichu
• 19,040 points
7,477 views
0 votes
0 answers

why is react native video not working on android, but working on ios?

installed react video v. 5.2.0 but an error ...READ MORE

Sep 23, 2022 in Others by gaurav
• 23,580 points
1,844 views
0 votes
1 answer

IF formula to compare a date with current date and return result

You can enter the following formula in ...READ MORE

Sep 27, 2022 in Others by narikkadan
• 86,360 points
1,677 views