Trending questions in Database

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 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

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
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

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
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

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
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
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 gaurav
• 12,980 points
35 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

#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 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

Importing images along with other fields (username,subjectname) from excel in laravel

$objphpexcel = PHPExcel_IOFactory::load("MyExcelFile.xls"); foreach ($objphpexcel ->getSheetByName("My Sheet1")->getDrawingCollection() as ...READ MORE

Apr 1 in Database by gaurav
• 12,980 points
259 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 in Database by Edureka
• 13,640 points
79 views
0 votes
1 answer

How to extract month name from custom date

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

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

How to refresh Excel file every second?

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

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

Convert Date to Text without losing the format in Excel?

The steps are as follows: Copy the dates ...READ MORE

Apr 1 in Database by gaurav
• 12,980 points
244 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
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

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 in Database by gaurav
• 12,980 points
28 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 in Database by Edureka
• 13,640 points
47 views
0 votes
1 answer

How to create an excel file in android?

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

Apr 4 in Database by Edureka
• 13,640 points
40 views
0 votes
1 answer

Write formula to Excel with Python

Using python to add formulas to an ...READ MORE

Mar 31 in Database by gaurav
• 12,980 points
268 views
0 votes
1 answer

Convert .xlsb to .xlsx - Multi-sheet Microsoft Excel File

xlsb can be read by newer versions ...READ MORE

Mar 30 in Database by gaurav
• 12,980 points
343 views
0 votes
1 answer

Returning outlook sender address from VBA in Excel

Returns a String that represents the sender ...READ MORE

Apr 4 in Database by gaurav
• 12,980 points
78 views
0 votes
1 answer

Calculate Growth rate in Excel

In order to get the Average Annual ...READ MORE

Apr 4 in Database by gaurav
• 12,980 points
71 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 in Database by gaurav
• 12,980 points
47 views
0 votes
1 answer

How to refresh Excel file every second?

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

Apr 4 in Database by Edureka
• 13,640 points
58 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
72 views
0 votes
1 answer

Login System in NodeJS & Excel

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

Apr 4 in Database by gaurav
• 12,980 points
50 views
0 votes
1 answer

How can we achieve excel ceiling function with significance value in SQL Server

If the underlying data types and rounding ...READ MORE

Apr 4 in Database by gaurav
• 12,980 points
43 views
0 votes
1 answer

Connection vs Query in Excel data model

There are various ways to construct and ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
56 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 in Database by gaurav
• 12,980 points
13 views
0 votes
1 answer

Excel 2010 CTRL+SHIFT+L. Not working

The Macro-containing workbook was always open in ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
46 views
0 votes
1 answer

Excel Date Formatting

Take the following steps: Choose the cells you ...READ MORE

Apr 4 in Database by gaurav
• 12,980 points
30 views
0 votes
1 answer

Excel Middle mouse button click not scrolling

Workbook and Protected Sheet If the sheets are ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
27 views
0 votes
1 answer

Excel problem for beginners: #REF! Error When referenced Row is deleted or Added

You'll run into this problem if you ...READ MORE

Apr 4 in Database by gaurav
• 12,980 points
30 views
0 votes
1 answer

macro in excel tablet

Add Macros to the Ribbon Tab You'll make ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
21 views
0 votes
1 answer

How to enter a series of numbers automatically in Excel

Excel, unlike other Microsoft Office programmes, does ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
25 views
0 votes
1 answer

Using SQL "IN" Function in Excel

MATCH is a word that can be ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
22 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

Apr 4 in Database by Edureka
• 13,640 points
23 views
0 votes
1 answer

How to translate a BDS excel-formula to XBBG API for Python

The parameters are improperly specified by you. ...READ MORE

Apr 1 in Database by gaurav
• 12,980 points
96 views
0 votes
0 answers

How to loop in excel without VBA or macros?

Is it possible to iterate (loop) a ...READ MORE

Mar 30 in Database by Edureka
• 13,640 points
158 views
0 votes
1 answer

Laravel Excel import using Maatwebsite Excel package with additional columns from View

How to fix: I know you're fed ...READ MORE

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

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

Mar 30 in Database by gaurav
• 12,980 points
210 views
0 votes
1 answer

Java Apache POI Excel save as PDF

For the software to run, you'll need ...READ MORE

Mar 31 in Database by gaurav
• 12,980 points
75 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

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

How do I display a ratio in Excel in the format A:B?

Try this formula: =SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":") Result: A B ...READ MORE

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

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

"Runtime Error 91: Object variable or with ...READ MORE

Mar 30 in Database by gaurav
• 12,980 points
186 views
0 votes
1 answer

Generating username from first name and last name in excel

How to automatically merge first and last ...READ MORE

Mar 30 in Database by gaurav
• 12,980 points
113 views