Trending questions in Edureka Community

0 votes
1 answer

Excel VBA - downloading multiple historical exchange rates

Do columns C and D contain your ...READ MORE

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

1-step shortcut to delete entire row in excel 2016

Highlight the whole row by clicking on ...READ MORE

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

TypeScript: How do you loop through a dictionary?

To loop over the key/values, use a for ...READ MORE

May 31, 2022 in TypeSript by Nina
• 3,060 points
7,597 views
0 votes
0 answers

When do Java generics require <? extends T> instead of <T> and is there any downside of switching?

Given the following example (using JUnit with ...READ MORE

Sep 29, 2022 in Java-Script by Abhinaya
• 1,160 points
2,414 views
0 votes
0 answers

Excel: Remove Duplicates based on time condition

A 3 month rolling time condition is ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
847 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,825 views
0 votes
1 answer

Statistical Kurtosis in relation to SPSS and MS excel

Kurtosis does not measure "peakedness" or "height" ...READ MORE

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

Using Excel Proper Function with exception | Excel

To accomplish this, you might need to ...READ MORE

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

Conditional Formatting (IF not empty)

 Use Conditional formatting with the option "Formula ...READ MORE

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

Convert Number to Words in Indian currency format with paise value

Use this code and check  <?php /** ...READ MORE

Apr 11, 2022 in Database by gaurav
• 24,860 points
9,718 views
0 votes
0 answers

How to store image in SQLite database

I want to upload an image from ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
3,969 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
8,529 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
2,732 views
0 votes
1 answer

Excel VBA Worksheet Range storage location best practices

Solution Changing Worksheets' Code Name Why dim srcSheet as myWorksheet when ...READ MORE

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

SQL keys, MUL vs PRI vs UNI

It denotes that the field is (a ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
3,203 views
0 votes
0 answers

JQuery Validation - Remote method always check and become true before submit the form

Using jQuery validation plugin, I have been ...READ MORE

Aug 24, 2022 in Web Development by gaurav
• 24,860 points
3,901 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
2,177 views
0 votes
1 answer

What is the previous block hash of block #4390176 in Ethereum Blockchain

0xc253f0917b33b2947b4d9cdb7ad656cc0233ef1781984384284f3a91810a8a36 Th ...READ MORE

Oct 14, 2023 in Blockchain by Rishav Utkarsh

edited Mar 5, 2025 13,741 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
2,255 views
0 votes
0 answers

SqlServer: Login failed for user

I created a pretty straightforward JDBC login ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,000 points
1,586 views
0 votes
0 answers

What is the purpose of using WHERE 1=1 in SQL statements?

Possible Duplicates: Why would a sql query have ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,000 points
3,657 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
2,573 views
0 votes
1 answer

Counting distinct values in excel - frequency function

You can use COUNTIF to count the ...READ MORE

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

TypeError: $(...).autocomplete is not a function

You would definitely have missed the Jquery ...READ MORE

Feb 23, 2022 in JQuery by Aditya
• 7,680 points
11,677 views
0 votes
1 answer

Excel VBA - Trouble importing WhatsApp chat history files into an Excel sheet

Since the OpenText method isn't working for ...READ MORE

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

VBA, Query Vertica database and populate to excel

You can query Vertica directly from excel. I ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 86,360 points
2,477 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,730 points

edited Mar 4, 2025 472 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,277 views
0 votes
1 answer

jQuery fix for "Uncaught TypeError: $ is not a function" error

We can fix this error by using jQuery() . ...READ MORE

Jun 1, 2022 in JQuery by Edureka
• 13,690 points
7,423 views
0 votes
2 answers

Excel VBA App stops spontaneously with message "Code execution has been halted"

Solution Press the "Debug" button in the popup. Press Ctrl+Pause|Break twice. Hit ...READ MORE

Sep 29, 2022 in Others by narikkadan
• 86,360 points
2,267 views
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,596 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,133 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
2,090 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
1,466 views
0 votes
1 answer

HTTP live streaming server on iPhone

AZ TESTING FOR QA READ MORE

Oct 4, 2022 in IOS by anonymous

edited Mar 5, 2025 2,252 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 462 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
2,193 views
0 votes
1 answer

JQuery Difference between hide() and fadeOut() , show() and fadeIn()

Main difference between FadeIn, FadeOut vs hide, ...READ MORE

Aug 5, 2022 in Web Development by rajatha
• 7,680 points
4,592 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,433 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,359 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 86,360 points
2,400 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,482 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
4,490 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,207 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,341 views
0 votes
0 answers

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

I am getting this JDBC exception. I ...READ MORE

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

Detecting iPhone 6/6+ screen sizes in point values

The device screen will be the first ...READ MORE

Sep 22, 2022 in IOS by Rahul
• 9,690 points
2,487 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,088 views