Latest questions in Database

0 votes
0 answers

ORA-00904: invalid identifier

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

May 20 in Database by Kichu
• 19,040 points
42 views
0 votes
0 answers

phpMyAdmin - Error > Incorrect format parameter?

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

May 19 in Database by Kichu
• 19,040 points
89 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
• 19,040 points
160 views
0 votes
1 answer

Disable Sorting in excel

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

Apr 11 in Database by gaurav
• 12,980 points
46 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 gaurav
• 12,980 points
227 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 gaurav
• 12,980 points
45 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 gaurav
• 12,980 points
574 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 gaurav
• 12,980 points
26 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 gaurav
• 12,980 points
28 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 gaurav
• 12,980 points
126 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 gaurav
• 12,980 points
81 views
0 votes
1 answer

Excel Remove Decimal Places

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

Apr 11 in Database by gaurav
• 12,980 points
31 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 gaurav
• 12,980 points
122 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
• 13,640 points
25 views
0 votes
0 answers

Unprotect workbook without password

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

Apr 7 in Database by Edureka
• 13,640 points
24 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
• 13,640 points
45 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
• 13,640 points
15 views
0 votes
0 answers

Datatables export Excel

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

Apr 7 in Database by Edureka
• 13,640 points
71 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
• 13,640 points
20 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
• 13,640 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
• 13,640 points
21 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
• 13,640 points
19 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
• 13,640 points
15 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 gaurav
• 12,980 points
45 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 gaurav
• 12,980 points
161 views
0 votes
1 answer

Vlookup Formula in Excel VBA

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

Apr 11 in Database by gaurav
• 12,980 points
37 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 gaurav
• 12,980 points
48 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 gaurav
• 12,980 points
30 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 gaurav
• 12,980 points
513 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 gaurav
• 12,980 points
18 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 gaurav
• 12,980 points
29 views
0 votes
0 answers

Make sentence from data in cells in Excel

I have a form with three cells ...READ MORE

Apr 6 in Database by Edureka
• 13,640 points
27 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 gaurav
• 12,980 points
31 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 gaurav
• 12,980 points
751 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 gaurav
• 12,980 points
26 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 gaurav
• 12,980 points
385 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 gaurav
• 12,980 points
21 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 gaurav
• 12,980 points
40 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 gaurav
• 12,980 points
94 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 gaurav
• 12,980 points
35 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 gaurav
• 12,980 points
56 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 gaurav
• 12,980 points
42 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 gaurav
• 12,980 points
292 views
0 votes
1 answer

Disable Sorting in excel

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

Apr 5 in Database by gaurav
• 12,980 points
121 views
0 votes
1 answer

Excel vba for loop

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

Apr 5 in Database by gaurav
• 12,980 points
68 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 gaurav
• 12,980 points
49 views
0 votes
1 answer

Excel formula get value just greater than an other

We can use the Search function in ...READ MORE

Apr 5 in Database by gaurav
• 12,980 points
110 views
0 votes
1 answer

How to type Unicode currency character in Visual Basic Editor

VBA editor is not Unicode. In order to ...READ MORE

Apr 5 in Database by gaurav
• 12,980 points
27 views
0 votes
1 answer

Excel formula for greater than but less than with several tiers

Use this: =MATCH(A1,{0,35,60,85,110}) READ MORE

Apr 5 in Database by gaurav
• 12,980 points
45 views
0 votes
1 answer

Excel .xlsx download - sharing violation error message on Open and Save combination

I believe there is a fault in ...READ MORE

Apr 5 in Database by gaurav
• 12,980 points
56 views