Trending questions in Edureka Community

0 votes
1 answer

Updating Powerpoint - Excel Link in Different Computer

You could look at the Excel shape's ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 86,360 points • 1,729 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,740 points
edited Mar 4, 2025 • 573 views
0 votes
1 answer

Excel plot against a date time x series [closed]

Try using an X-Y Scatter graph with ...READ MORE

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

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

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

Download multiple excel files linked through urls in R

Try something along the lines of: for (i ...READ MORE

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

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 86,360 points • 2,523 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 • 4,377 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 • 2,515 views
0 votes
1 answer

TypeScript and React Native: Are the type definitions for RN styles wrong?

You can test some of ways for ...READ MORE

Jun 10, 2022 in TypeSript by Nina
 • 3,060 points • 7,158 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,828 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 • 8,249 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 • 2,305 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 2,303 views
+1 vote
0 answers

Android Open External Storage directory(sdcard) for storing file

For programmatic file saving, I want to ...READ MORE

Sep 21, 2022 in Android by Edureka
 • 13,740 points • 2,637 views
0 votes
1 answer

How to freeze an area in Excel?

Excel has a "Freeze panes" for this, ...READ MORE

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

What is an Intent in Android?

I have a few questions related to ...READ MORE

Nov 9, 2022 in Android by Edureka
 • 12,730 points
edited Mar 4, 2025 • 549 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 • 2,656 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 • 2,408 views
0 votes
0 answers

How to get webriver io typescript working wdio wizard?

I'm Putting together a WebdriverIO project with ...READ MORE

Jul 5, 2022 in TypeSript by Nina
 • 3,060 points • 2,529 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Use the sp_columns stored procedure: exec sp_columns MyTable I hope this ...READ MORE

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

Equivalent of Excel Round function

Here's a sample LINQPad program that demonstrates one way ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 86,360 points • 2,436 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,759 views
0 votes
0 answers

What is the difference between iostream , stdio.h and conio.h header files in c++?

I am confused between all these three ...READ MORE

Sep 23, 2022 in Others by gaurav
 • 25,250 points • 2,548 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 86,360 points • 2,464 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
 • 25,250 points • 1,610 views
0 votes
0 answers

when I try to open an HTML file through `http://localhost/xampp/htdocs/index.html` it says unable to connect to localhost?

When I try to open the index.html ...READ MORE

Jul 19, 2022 in HTML by Tejashwini
 • 5,380 points • 5,381 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 • 2,183 views
0 votes
1 answer

How to open an Excel Online document as a PDF

In light of your comment above, I ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 1,420 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,780 views
0 votes
1 answer

VBA to unhide a column when opening a workbook

Use the workbook_open even within ThisWorkbook. READ MORE

Oct 20, 2022 in Others by narikkadan
 • 86,360 points • 1,302 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 • 8,112 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 • 2,398 views
0 votes
1 answer

Cannot open local file - Chrome: not allowed to load local resource angular

To answer your query, start with opening ...READ MORE

Feb 18, 2022 in Java by Aditya
 • 7,680 points • 11,811 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
 • 25,250 points • 1,551 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,846 views
0 votes
1 answer

Can't start Eclipse - Java was started but returned exit code=13

Your version of Eclipse is 64-bit, based ...READ MORE

Sep 20, 2022 in Java-Script by Abhinaya
 • 1,160 points • 2,575 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 • 2,032 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,751 views
0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

The majority of the responses to this ...READ MORE

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

PL/MySQL does it exist?

Despite the fact that MySQL and PL/SQL ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 86,360 points • 2,960 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 • 2,285 views
0 votes
0 answers

Real iPhone XR screen resolution differs from screen resolution given by swift?

Screenshots, the Apple website, and other sources ...READ MORE

Sep 28, 2022 in IOS by Soham
 • 9,730 points • 2,198 views
0 votes
1 answer

Calculate a Running Total in SQL Server

The problem is that the SQL Server ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 86,360 points • 2,946 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
 • 25,250 points • 1,506 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,721 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

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

How to install modules in Pycharm?

You can install modules in PyCharm using ...READ MORE

May 30, 2019 in Python by Shabnam
 • 930 points • 54,723 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,740 points • 2,304 views
0 votes
3 answers

Python pandas: TypeError: tuple indices must be integers or slices, not str

In fact, I get a perfectly good ...READ MORE

Jun 13, 2019 in Python by Alok
 • 55,696 views
0 votes
1 answer

SQL JOIN - WHERE clause vs. ON clause

They are not the same thing. Consider these ...READ MORE

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