Latest questions in Database

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,670 points • 770 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,670 points • 203 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,670 points • 284 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,670 points • 231 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,670 points • 367 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
 • 23,260 points • 761 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
 • 23,260 points • 1,045 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
 • 23,260 points • 710 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
 • 23,260 points • 1,024 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
 • 23,260 points • 1,592 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
 • 23,260 points • 10,674 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
 • 23,260 points • 2,095 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
 • 23,260 points • 4,695 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,670 points • 716 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
 • 23,260 points • 1,514 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
 • 23,260 points • 9,005 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
 • 23,260 points • 5,628 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
 • 23,260 points • 7,609 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
 • 23,260 points • 1,291 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
 • 23,260 points • 13,698 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
 • 23,260 points • 1,180 views
–1 vote
1 answer

Add common prefix to all cells in Excel

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

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 64,700 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
 • 23,260 points • 682 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
 • 23,260 points • 1,145 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
 • 23,260 points • 158,734 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
 • 23,260 points • 5,359 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
 • 23,260 points • 431 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
 • 23,260 points • 1,119 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
 • 23,260 points • 1,680 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
 • 23,260 points • 837 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
 • 23,260 points • 6,277 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
 • 23,260 points • 829 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
 • 23,260 points • 401 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
 • 23,260 points • 732 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
 • 23,260 points • 1,077 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
 • 23,260 points • 362 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
 • 23,260 points • 255 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,670 points • 3,016 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,670 points • 1,030 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,670 points • 15,728 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, 2022 in Database by Edureka
 • 13,670 points • 7,139 views
0 votes
1 answer

What is the best library in python to deal with excel files?

XlsxWriter and Xlwings are the best, in ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,670 points • 3,277 views
0 votes
1 answer

How to add a named sheet at the end of all Excel sheets?

Kindly use this one liner: Sheets.Add(After:=Sheets(Sheets.Count)).Name = "new_sheet_name" Or ...READ MORE

Apr 5, 2022 in Database by gaurav
 • 23,260 points • 428 views
0 votes
1 answer

Number Formatting to 10K 5M, etc in Excel 2016

In the format of a user-defined number [>=1000000]0,,"M";[>=1000]0,"K";0 The ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,670 points • 1,284 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, 2022 in Database by Edureka
 • 13,670 points • 3,208 views
0 votes
1 answer

How to refresh Excel file every second?

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

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

Merge multiple Excel sheets into one sheet

Merging Excel Sheets: A Step-by-Step Guide Make sure ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 6,575 views
0 votes
1 answer

Login System in NodeJS & Excel

This sample contains five javascript files. request-router.js: This ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 333 views
0 votes
1 answer

Setting mime type for excel document

I assume application/vnd.ms-excel is the standard MIME ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 11,422 views
0 votes
1 answer

Pandas cannot open an Excel (.xlsx) file

XLRDError: Excel xlsx file not supported by ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 4,748 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.