Trending questions in Edureka Community

0 votes
1 answer

Merge and export Excel/Word/PDF to PDF

Use GroupDocs.Merger for .NET API to merge Word, Excel, ...READ MORE

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

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

Oct 7, 2022 in Others by narikkadan
• 63,600 points
1,283 views
+1 vote
1 answer

"msg": "Using a SSH password instead of a key is not possible because Host Key checking is enabled and sshpass does not support this.

Hi@akhtar, You are getting this error because when ...READ MORE

Aug 1, 2020 in Ansible by MD
• 95,460 points
35,662 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
• 63,600 points
617 views
0 votes
1 answer

The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path

Include servlet-api-3.1.jar in your dependencies. Maven <dependency> <groupId>javax.servlet</groupId> ...READ MORE

Sep 20, 2022 in Java-Script by Abhinaya
• 1,160 points
1,985 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

Oct 17, 2022 in Others by narikkadan
• 63,600 points
823 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
• 63,600 points
606 views
0 votes
1 answer

Protect excel sheet but allow data entry with form

Try this: Private Sub Workbook_Open() ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 63,600 points
1,571 views
0 votes
1 answer

Quadratic and cubic regression in Excel

You need to use an undocumented trick ...READ MORE

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

How do I calculate Interest rate (R) from EMI formula if I know EMI, Principal (P) and Time (N)?

Try this: #include <iostream> #include <cmath> #include <boost/date_time/posix_time/posix_time.hpp> #include <boost/thread/thread.hpp> #define TOLERANCE ...READ MORE

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

Converting all tabs of excel sheet to PDF

Using VBA, try it like this, for ...READ MORE

Sep 26, 2022 in Others by narikkadan
• 63,600 points
1,736 views
0 votes
0 answers

How do I add my logo to my website using html

I already have a website set up, ...READ MORE

Aug 8, 2022 in HTML by Tejashwini
• 780 points
3,841 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
• 63,600 points
579 views
0 votes
1 answer

Is SQL syntax case sensitive?

The SQL keywords (SELECT, FROM, WHERE, etc.) ...READ MORE

Feb 16, 2022 in Database by Vaani
• 7,070 points
11,260 views
0 votes
0 answers

Jquery: Get each image src

I have a series of images each ...READ MORE

Aug 11, 2022 in Web Development by gaurav
• 23,260 points
3,704 views
0 votes
1 answer

What is record in TypeScript

A Record<K, T> is an object type whose property ...READ MORE

Jun 7, 2022 in TypeSript by Nina
• 3,060 points
6,549 views
0 votes
1 answer

Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

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

The specified child already has a parent. You must call removeView() on the child's parent first (Android)

The error message says what You should ...READ MORE

Feb 16, 2022 in Java by Aditya
• 7,680 points
11,245 views
0 votes
1 answer

I want to create a small square colour filled box in HTML & CSS. And most important - I want to write one line after the box

Try using the square html entity: <div style="color:blue">&a ...READ MORE

Jun 28, 2022 in CSS by Edureka
• 12,690 points
5,718 views
0 votes
1 answer

NodeJS Amazon AWS S3 getObject how to send file in API response to download

Server Side const aws = require('aws-sdk'); router.get('/getfilefroms3', async (req, ...READ MORE

Mar 24, 2022 in Others by gaurav
• 23,260 points
9,760 views
0 votes
1 answer

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

 I ran into the same problem due ...READ MORE

Feb 23, 2022 in Others by Aditya
• 7,680 points
10,939 views
0 votes
0 answers

Uninstall php 7 in ubuntu 18.04

I have a server with a PHP ...READ MORE

Aug 2, 2022 in PHP by Kithuzzz
• 38,000 points
4,086 views
0 votes
0 answers

how to get values of columns for a selected row through jQuery

here i am trying to fetch values ...READ MORE

Jul 1, 2022 in Web Development by gaurav
• 23,260 points
5,437 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

Oct 18, 2022 in Others by narikkadan
• 63,600 points
708 views
0 votes
0 answers

Laravel - htmlspecialchars() expects parameter 1 to be string, object given

I got this error: htmlspecialchars() expects parameter 1 ...READ MORE

Aug 10, 2022 in HTML by Deepak
• 980 points
3,706 views
0 votes
1 answer

How do I limit the number of rows returned by an Oracle query after ordering?

Use a subquery for this like: select * from ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
2,170 views
0 votes
1 answer

How to Execute SQL Server Stored Procedure in SQL Developer?

You don't need EXEC clause. Simply use: proc_name ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,600 points
2,099 views
0 votes
1 answer

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

Oct 8, 2022 in Others by narikkadan
• 63,600 points
1,126 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
• 63,600 points
512 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
1,522 views
0 votes
1 answer

ActiveWorkbook.SaveAs excel 2013 1004 error

Error reproduction: I was able to reproduce the ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,683 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
• 63,600 points
712 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
• 63,600 points
832 views
0 votes
1 answer

Difference between numeric, float and decimal in SQL Server

use the float or real data types only if the precision provided by decimal (up ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 63,600 points
2,259 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
• 63,600 points
572 views
0 votes
0 answers

Error converting data type nvarchar to datetime SQL Server

I encountered this error: Error converting data type ...READ MORE

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

Adding Signature Line Word-Excel

Since there doesn't appear to be a ...READ MORE

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

Online MYSQL editor as an Excel-like spreadsheet

That depends on who are those users, ...READ MORE

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

How to pass text/plain content in axios POST request in nodejs?

var config = { ...READ MORE

Jun 14, 2022 in Node-js by Neha
• 9,020 points
6,039 views
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
• 63,600 points
616 views
0 votes
0 answers

Error - Android resource linking failed (AAPT2 27.0.3 Daemon #0)

I have this error I am try reinstall ...READ MORE

Sep 21, 2022 in Android by Edureka
• 13,620 points
1,793 views
0 votes
1 answer

Subtotal in result row returns 0 in excel table

Syntax SUBTOTAL(function_num,ref1,[ref2],...) The SUBTOTAL function syntax has the following ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,626 views
0 votes
1 answer

SharePoint - Excel Online - Edit in Excel and Edit in Browser multiple users

Here is the Microsoft article regarding co-authoring https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US When ...READ MORE

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

Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

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

Repeated Multiplication formula for Excel

Fun little problem using some basic maths: =A1*3^ROW(A1) READ MORE

Oct 8, 2022 in Others by narikkadan
• 63,600 points
1,024 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
• 63,600 points
497 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
• 63,600 points
483 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
• 63,600 points
441 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

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

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

Oct 14, 2022 in Others by narikkadan
• 63,600 points
736 views