Most voted questions in Database

0 votes
1 answer

Strange and Incorrect Excel Formulas Result?

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
172 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, 2022 in Database by gaurav
• 22,980 points
121 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, 2022 in Database by gaurav
• 22,980 points
1,413 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, 2022 in Database by gaurav
• 22,980 points
1,509 views
0 votes
1 answer

Excel Remove Decimal Places

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
239 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, 2022 in Database by gaurav
• 22,980 points
108,822 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, 2022 in Database by Edureka
• 13,630 points
261 views
0 votes
0 answers

Unprotect workbook without password

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

Apr 7, 2022 in Database by Edureka
• 13,630 points
168 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, 2022 in Database by Edureka
• 13,630 points
410 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, 2022 in Database by Edureka
• 13,630 points
111 views
0 votes
0 answers

Datatables export Excel

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

Apr 7, 2022 in Database by Edureka
• 13,630 points
676 views
0 votes
0 answers

Excel formula for reverse percentage calculation

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

Apr 7, 2022 in Database by Edureka
• 13,630 points
408 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, 2022 in Database by Edureka
• 13,630 points
97 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, 2022 in Database by Edureka
• 13,630 points
145 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, 2022 in Database by Edureka
• 13,630 points
121 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, 2022 in Database by Edureka
• 13,630 points
207 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, 2022 in Database by gaurav
• 22,980 points
540 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, 2022 in Database by gaurav
• 22,980 points
738 views
0 votes
1 answer

Vlookup Formula in Excel VBA

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
449 views
0 votes
1 answer

VBA Excel - Replace Enter key with Alt+ Enter

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
677 views
0 votes
1 answer

Excel - Create item list from table values

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
689 views
0 votes
1 answer

Use python extract images from Excel sheets

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
6,281 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, 2022 in Database by gaurav
• 22,980 points
946 views
0 votes
1 answer

Excel sort function to "skip" 1st row

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

Apr 11, 2022 in Database by gaurav
• 22,980 points
2,072 views
0 votes
0 answers

Make sentence from data in cells in Excel

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

Apr 6, 2022 in Database by Edureka
• 13,630 points
430 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, 2022 in Database by gaurav
• 22,980 points
937 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, 2022 in Database by gaurav
• 22,980 points
6,618 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, 2022 in Database by gaurav
• 22,980 points
2,747 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, 2022 in Database by gaurav
• 22,980 points
5,213 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, 2022 in Database by gaurav
• 22,980 points
904 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, 2022 in Database by gaurav
• 22,980 points
3,882 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, 2022 in Database by gaurav
• 22,980 points
790 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, 2022 in Database by gaurav
• 22,980 points
427 views
0 votes
1 answer

Algorithm used in Excel Fuzzy Lookup

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

Apr 6, 2022 in Database by gaurav
• 22,980 points
654 views
0 votes
1 answer

Excel convert column to comma separated

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

Apr 6, 2022 in Database by gaurav
• 22,980 points
89,638 views
0 votes
1 answer

Disable Sorting in excel

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

Apr 5, 2022 in Database by gaurav
• 22,980 points
3,835 views
0 votes
1 answer

Excel vba for loop

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

Apr 5, 2022 in Database by gaurav
• 22,980 points
244 views
0 votes
1 answer

#NAME? error in Excel for VBA Function

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

Apr 5, 2022 in Database by gaurav
• 22,980 points
506 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, 2022 in Database by gaurav
• 22,980 points
1,062 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, 2022 in Database by gaurav
• 22,980 points
412 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, 2022 in Database by gaurav
• 22,980 points
4,197 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, 2022 in Database by gaurav
• 22,980 points
463 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, 2022 in Database by gaurav
• 22,980 points
220 views
0 votes
1 answer

How to extract month name from custom date

The steps to accomplish so are as ...READ MORE

Apr 5, 2022 in Database by gaurav
• 22,980 points
372 views
0 votes
1 answer

How to refresh Excel file every second?

Data should be refreshed at regular intervals. Select ...READ MORE

Apr 5, 2022 in Database by gaurav
• 22,980 points
655 views
0 votes
0 answers

How do I merge two rows in Excel?

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

Apr 4, 2022 in Database by gaurav
• 22,980 points
153 views
0 votes
0 answers

How to split a string of text in excel based on a given word?

I have a list of combinations of ...READ MORE

Apr 4, 2022 in Database by gaurav
• 22,980 points
137 views
0 votes
1 answer

CountifS + multiple criteria + distinct count

Please enter this formula into a blank ...READ MORE

Apr 4, 2022 in Database by Edureka
• 13,630 points
1,559 views
0 votes
1 answer

How to create an excel file in android?

In Android, create Excel XLSX or XLS ...READ MORE

Apr 4, 2022 in Database by Edureka
• 13,630 points
663 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, 2022 in Database by Edureka
• 13,630 points
9,841 views