Trending questions in Edureka Community

0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

The lack of an underscore between "chartered" ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
2,537 views
0 votes
0 answers

Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
418 views
0 votes
1 answer

Excel custom format: What does [$€-2] mean?

The 2 in [$€-2] is a "Numeral ...READ MORE

Oct 30, 2022 in Others by narikkadan
• 63,600 points
541 views
0 votes
0 answers

Writing a typescript declaration file for an external js nodejs package, without type info

I'm writing a node js typescript library ...READ MORE

Aug 19, 2022 in Node-js by Neha
• 9,020 points
3,656 views
0 votes
0 answers

Creating a chart in Excel that ignores #N/A or blank cells

A dynamic data series will be used ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
404 views
0 votes
1 answer

Highest Salary in each department

SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY ...READ MORE

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

Excel viewer lib

You will need to save your excel ...READ MORE

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

Insert pie chart in Excel macro function

Think about arranging your data in a ...READ MORE

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

How to manually piece together a fraction on excel

Instead of controlling formatting in your calculations, ...READ MORE

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

Tab Delimited Text Copy Paste To Excel

By switching the element my text was ...READ MORE

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

jquery check if radio button is checked and then check if tickbox is checked

This is the best and the most ...READ MORE

Aug 1, 2022 in Web Development by rajatha
• 7,680 points
4,373 views
0 votes
1 answer

Amortization schedule for many rows using Excel Macro

Try this: Sub one() Dim intRate, loanLife, initLoan, payment ...READ MORE

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

Shortcut to Apply a Formula to an Entire Column in Excel

Try double-clicking on the bottom right hand ...READ MORE

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

How to express absolute cell references in Excel R1C1-style formulas?

If the formulas are in Column K ...READ MORE

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

Too Many Different Cell Formats

Cell formats are challenging. There isn't actually ...READ MORE

Oct 28, 2022 in Others by narikkadan
• 63,600 points
583 views
0 votes
0 answers

Simple way to transpose columns and rows in SQL?

How can I quickly switch rows and ...READ MORE

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

How can I copy from specific sheet in excel

You should use wb.Sheets("Name of sheet").Copy - ...READ MORE

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

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

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

Excel Arrow Key is Creating a Formula?

Your scroll lock is on. This is ...READ MORE

Oct 23, 2022 in Others by narikkadan
• 63,600 points
790 views
0 votes
0 answers

SUBSTR and INSTR SQL Oracle

I've begun utilising SUBSTR and INSTR in ...READ MORE

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

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

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

Create charts in excel sheet [ in same sheet along with data C#]

Unfortunately, it's not that simple. Use the ...READ MORE

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

Excel formatting DD-MMM-YYYY, must be in this format

There is no special structure for months ...READ MORE

Oct 10, 2022 in Others by narikkadan
• 63,600 points
1,330 views
0 votes
0 answers

Excel formula converting tan to angle

I have an excel spreadsheet that computes ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
420 views
0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

Oct 21, 2022 in Others by narikkadan
• 63,600 points
841 views
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,637 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
323 views
0 votes
1 answer

If Statement Not Working When Including Cells That Have Formulas

Try:  =IF(VALUE(A1)>10;1;0) I hope this helps you. READ MORE

Oct 23, 2022 in Others by narikkadan
• 63,600 points
750 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,481 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
4,049 views
0 votes
1 answer

Export HTML Table to Excel- Doesn't Open in Office 2010

We had the same issue too many ...READ MORE

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

Xls to csv converter

Use xlrd - it's faster, cross-platform, and ...READ MORE

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

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Create a UDF that uses VBA's version ...READ MORE

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

Data entry into web page from excel

Reading the File in PHP Example 1 How to ...READ MORE

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

How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

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

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

Oct 10, 2022 in Others by narikkadan
• 63,600 points
1,279 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,920 views
0 votes
0 answers

send images on whatsapp web with javascript DOM

I currently have the script that delivers ...READ MORE

Sep 28, 2022 in Java by Nicholas
• 7,760 points
1,808 views
0 votes
0 answers

xcel VBA Chart counting and formatting

I want to develop a macro that ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
380 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,290 views
0 votes
1 answer

Speed up Excel vba program

Not at all. I used it. You ...READ MORE

Oct 20, 2022 in Others by narikkadan
• 63,600 points
837 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
11,121 views
0 votes
0 answers

locked textbox property set to true at worksheet

Hello, I have textboxes (activeX controls) on ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
348 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,694 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,356 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,360 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,639 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,911 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,849 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,295 views