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 • 786 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 • 215 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 • 295 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 • 236 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 • 377 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 • 776 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,064 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 • 726 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,038 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,634 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,894 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,135 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,836 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 • 734 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,539 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,129 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,735 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,672 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,314 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 • 14,490 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,214 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 • 66,029 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 • 701 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,182 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 • 161,828 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,400 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 • 445 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,158 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,733 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 • 867 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,346 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 • 860 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 • 423 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 • 751 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,095 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 • 379 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 • 265 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,077 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,047 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 • 16,018 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,194 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,308 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 • 437 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,298 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,253 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 • 1,009 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,623 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 • 347 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,665 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,837 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.