Trending questions in Database

0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

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

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 1,812 views
0 votes
1 answer

excel Copy shapes from one worksheet to another

This will copy all the shapes from Sheet1 to Sheet2: Sub ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 1,036 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,670 points • 752 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

Versions 3.5 and 2.0 of the NET ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 1,287 views
0 votes
1 answer

Disable Sorting in excel

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

Apr 11, 2022 in Database by gaurav
 • 23,260 points • 477 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 • 726 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 • 706 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 • 674 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,670 points • 647 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
 • 23,260 points • 398 views
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
 • 23,260 points • 350 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, 2022 in Database by gaurav
 • 23,260 points • 691 views
0 votes
1 answer

How to insert date values into table?

You have to convert the literal to ...READ MORE

Feb 18, 2022 in Database by Vaani
 • 7,020 points • 2,560 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
 • 23,260 points • 307 views
0 votes
1 answer

How to Convert Excel Numeric Cell Value into Words

To translate numbers to words, create the ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 796 views
0 votes
1 answer

Exception Visual Basic .NET Clipboard Text to Excel Via Interop/Worksheet.Paste()

So, here's what I did to address ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 913 views
0 votes
1 answer

SQL error "ORA-01722: invalid number"

When an effort is made to convert ...READ MORE

Feb 15, 2022 in Database by Neha
 • 9,060 points • 2,626 views
0 votes
1 answer

Count colored cell on excel automatically

Use Filter and SUBTOTAL to Count Colored ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 847 views
0 votes
1 answer

Count unique values in a column in Excel

Excel may be used to count unique ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 839 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,670 points • 419 views
0 votes
1 answer

macro in excel tablet

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

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

Why is there still a row limit in Microsoft Excel?

Because of optimizations, most likely. There are ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 719 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 • 394 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, 2022 in Database by gaurav
 • 23,260 points • 617 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 • 416 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 • 353 views
0 votes
1 answer

How to convert a column number (e.g. 127) into an Excel column (e.g. AA)

If anyone needs to do this in ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 712 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,670 points • 293 views
0 votes
1 answer

Remove time from date field in Excel formula

Use the Find And Replace function to ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 692 views
0 votes
1 answer

Excel TEXT formula doesn't convert 'yyyy' to a year

It appears that if you have a ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 692 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 • 271 views
0 votes
1 answer

Excel Date Formatting

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

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

How to Calculate DATEDIF formula in Excel?

Simply divide one date by the other. ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 781 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 • 357 views
0 votes
1 answer

Using SQL "IN" Function in Excel

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

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

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 554 views
0 votes
1 answer

Hours and minutes difference between two times in Excel

Using the TEXT function in Excel is ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 762 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 • 197 views
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 1,247 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, 2022 in Database by Edureka
 • 13,670 points • 349 views
0 votes
1 answer

How to sort by dates excel?

You can sort dates in a worksheet ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 504 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 • 328 views
0 votes
1 answer

Excel function to return a nested SEQUENCE within COMBIN()

You could do it with a triangular ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 711 views
0 votes
0 answers

Merging Two excel files as two sheets in one workbook in java

I have two xlsx files at folder ...READ MORE

Mar 10, 2022 in Database by Edureka
 • 13,670 points • 1,362 views
0 votes
1 answer

Importing Excel files into R, xlsx or xls

To get started, here's a template for ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 564 views
0 votes
1 answer

Get month and year from date cells Excel

The steps to modify the date format ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 560 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.