Trending questions in Edureka Community

0 votes
1 answer

How to export data with functions to another workbook in excel

The issue appears to be that once ...READ MORE

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

How do I protect all worksheet in an Excel workbook with a single click?

VBA Code : Dim ws as Worksheet Dim pwd ...READ MORE

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

How to open a huge excel file efficiently

A good example is using PIA's/Interop or ...READ MORE

Oct 27, 2022 in Others by narikkadan
• 63,600 points
803 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,533 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,272 views
0 votes
0 answers

Redirect users to different pages based on role php

Depending on the responsibilities that have been ...READ MORE

Jul 21, 2022 in PHP by narikkadan
• 63,600 points
5,063 views
0 votes
1 answer

Ignore text values in subtotal function

Use 7 as the second criterion in AGGREGATE instead ...READ MORE

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

Convert word document to excel

n essence, I had to change the ...READ MORE

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

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

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

Excel VBA Rnd Not Actually Random

 Initialize the random number function. Sub test() Dim number ...READ MORE

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

Detect whether Excel workbook is already open

Try this: Option Explicit Sub Sample() ...READ MORE

Oct 31, 2022 in Others by narikkadan
• 63,600 points
600 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
452 views
0 votes
0 answers

What is the difference between Java and C++?

What is the difference between Java and ...READ MORE

Jul 22, 2022 in C++ by Nicholas
• 7,760 points
463 views
0 votes
1 answer

Using Java to create PDF graphs based on Excel formulas

The Apache POI project, an API for ...READ MORE

Oct 22, 2022 in Others by narikkadan
• 63,600 points
983 views
0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
506 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,439 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
4,056 views
+5 votes
0 answers

How to delete my edureka account permanently?

Sep 6, 2020 in Others by Webinar
• 180 points
3,503 views
0 votes
1 answer

Excel to PDF C# library

These articles will be help for you ...READ MORE

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

Hovering over button highlights entire table

I amended a responsive html email template. ...READ MORE

Nov 9, 2022 in CSS by Mohammed

edited Mar 4 187 views
0 votes
1 answer

jQuery find, each, children and accessing sub-children

Well you code is not really correct. .find() does ...READ MORE

Jun 27, 2022 in Web Development by rajatha
• 7,680 points
5,981 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,469 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,736 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
596 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,388 views
0 votes
0 answers

How to cast a json in typescript?

How to remove properties automatictly? READ MORE

Nov 10, 2022 in TypeSript by Alexandre

edited Mar 4 151 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
630 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
459 views
0 votes
0 answers

Hovering over button highlights entire table

I amended a responsive html email template. ...READ MORE

Nov 9, 2022 in CSS by Mohammed

edited Mar 4 158 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,403 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,267 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
6,085 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,142 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,988 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,761 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,304 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
615 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
614 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,218 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
654 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,838 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
363 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
682 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
599 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
471 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
846 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
630 views
0 votes
1 answer

How to extract the regression coefficient from statsmodels.api?

The coefficients can be obtained using the ...READ MORE

Mar 17, 2022 in Machine Learning by Dev
• 6,000 points
10,359 views