Trending questions in Database

+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by Sahiti
• 6,360 points
69,070 views
0 votes
0 answers

ORA-00904: invalid identifier

I am getting this error while doing ...READ MORE

2 days ago in Database by Kichu
• 16,650 points
2 views
0 votes
0 answers

phpMyAdmin - Error > Incorrect format parameter?

I used this command: select database > ...READ MORE

3 days ago in Database by Kichu
• 16,650 points
11 views
0 votes
0 answers

Access denied for user 'root@localhost' (using password:NO)

I wanted to run WordPress and it ...READ MORE

May 8 in Database by Kichu
• 16,650 points
27 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 in Database by Edureka
• 8,820 points
82 views
0 votes
1 answer

Split timestamp column into separate date and time columns in excel

Kutools for Excel allows you to split ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
52 views
0 votes
1 answer

Excel VBA run-time error 1004 : Application-defined or object-defined error

Maybe your code is on Sheet 1, ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
49 views
0 votes
1 answer

Converting Excel Date Serial Number to Date using Javascript

Please do try this : function ExcelDateToJSDate(serial) { ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
39 views
0 votes
1 answer

Disable Sorting in excel

To quickly sort, select the Sort A ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
32 views
0 votes
1 answer

Excel Remove Decimal Places

INT function: Remove digits after decimal in ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
27 views
0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
27 views
0 votes
1 answer

Excel data to table on Dashing Dashboard?

It contains a feature named "Download." The ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
25 views
0 votes
1 answer

is there a shortcut to open filter>contains box in excel?

The shortcut for opening the filter drop-down ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
25 views
0 votes
1 answer

Strange and Incorrect Excel Formulas Result?

Because the value in cell B1 may ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
20 views
0 votes
1 answer

Use python extract images from Excel sheets

I found a solution # installing the modules pip3 ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
102 views
0 votes
1 answer

How to download created excel file in node.js using exceljs

Download a sample Excel file using Node. ...READ MORE

Apr 4 in Database by Edureka
• 9,320 points
249 views
0 votes
1 answer

Unable to compress excel file (XLSX or XLS) using java

Because the formats with a 'x' at ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
52 views
0 votes
1 answer

How to run a SQL query on an Excel table?

On Excel tables, how to construct and ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
24 views
0 votes
1 answer

VBA Excel - Replace Enter key with Alt+ Enter

I created Button1 and assigned the Enter ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
25 views
0 votes
1 answer

Vlookup Formula in Excel VBA

The VLOOKUP function can be used in ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
24 views
0 votes
1 answer

Excel sort function to "skip" 1st row

Select the column range you will sort ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer

Excel indirect reference produces a #ref error

The formula =SUM(B2,C2,D2) is used in column ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
22 views
0 votes
1 answer

Excel - Create item list from table values

What is Data Validation, and how does ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
16 views
0 votes
1 answer

Excel - count days in each month between two dates (both dates available)

Anyway, here's an alternative completeness approach based ...READ MORE

Apr 11 in Database by Edureka
• 8,820 points
14 views
0 votes
1 answer

How to open a password protected excel file using python?

I recently came upon a Python package ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
118 views
0 votes
1 answer

How to deal with "Microsoft Excel is waiting for another application to complete an OLE action"

The first step in troubleshooting is to ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
56 views
0 votes
1 answer

Maximum number of rows of CSV data in excel sheet

The maximum number of characters per cell ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
44 views
0 votes
1 answer

I have to convert utc time to ist in excel

There are no built-in functions for determining ...READ MORE

Apr 4 in Database by Edureka
• 9,320 points
114 views
0 votes
0 answers

EXCEL - How to create a custom cell format for an Australian phone number: xxxx-xxx-xxx

Australian mobile phone (cell phone) and land ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
25 views
0 votes
1 answer

Save dynamically created table content in excel file using SheetJS

text inside tr instead of td in dynamic content. This results ...READ MORE

Apr 4 in Database by Edureka
• 9,320 points
106 views
0 votes
1 answer

I have a Run Time Error 91 for an Excel Add In

When there was no unhidden workbook open ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
31 views
0 votes
0 answers

Unprotect workbook without password

I have a popular VBA code to ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
18 views
0 votes
1 answer

How do I split a cell in Excel into two or more where they are divided horizontally?

Table cells should be combined. To make a ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
26 views
0 votes
1 answer

Excel convert column to comma separated

The CONCATENATE function in Excel can transform ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
26 views
0 votes
0 answers

Datatables export Excel

I'm exporting the datatables in csv. And ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
14 views
0 votes
0 answers

How do I merge two rows in Excel?

Hi I'm not even sure if this ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
13 views
0 votes
0 answers

Excel - Find how many cells are in a range

For each cell in the column I ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
13 views
0 votes
1 answer

Excel vba for loop

You must understand how to use loops ...READ MORE

Apr 5 in Database by Edureka
• 8,820 points
51 views
0 votes
1 answer

Algorithm used in Excel Fuzzy Lookup

There are two data sets that must ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
22 views
0 votes
0 answers

How to add Indian Rupee Currency symbol in Google Spreadsheet

I need to add Indian Rupee Currency ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
10 views
0 votes
0 answers

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
11 views
0 votes
0 answers

Excel formula for reverse percentage calculation

I have a calculation which I am ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
10 views
0 votes
0 answers

Convert a vertical data in a excel sheet with one header

I have a problem converting a long ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
9 views
0 votes
0 answers

Why should I use the DIM statement in VBA or Excel?

So there is a question on what DIM is, but I ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
9 views
0 votes
1 answer

Disable Sorting in excel

You may discover that adding a filter, ...READ MORE

Apr 5 in Database by Edureka
• 8,820 points
47 views
0 votes
1 answer

EXCEL How to check if Column A contains specific value and Column B contains 2 specific values?

If you're looking for the string CHECK in cells ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
28 views
0 votes
1 answer

How to calculate student pass percentage in excel

Percentage formula in Excel In cell D2, type ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
12 views
0 votes
1 answer

IF excel formula like =IF(C6>=70,"Pass","Fail") throws error

Using Excel's IF & AND function Assume ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
13 views
0 votes
1 answer

Add common prefix to all cells in Excel

Using the Concatenate Function in Excel, you ...READ MORE

Apr 6 in Database by Edureka
• 8,820 points
13 views
0 votes
1 answer

#NAME? error in Excel for VBA Function

Because you have a module with the ...READ MORE

Apr 5 in Database by Edureka
• 8,820 points
34 views