Trending questions in Database

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,721 views
0 votes
1 answer

[Excel][VBA] How to draw a line in a graph?

Sub MakeChart() Dim x(20) ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,260 points
2,259 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,481 views
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
2,613 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,607 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,070 points
3,591 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,592 views
0 votes
1 answer

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

These techniques can add a running column ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,260 points
2,056 views
0 votes
1 answer

Easy way to export multiple data.frame to multiple Excel worksheets

To export numerous data frames from R ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,260 points
1,968 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,690 points
1,317 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
1,464 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,690 points
1,352 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,690 points
1,475 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
1,184 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,690 points
1,360 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,526 views
0 votes
1 answer

Excel - AVERAGEIFS with OR conditions?

The AVERAGEIFS function in Excel determines the ...READ MORE

Mar 31, 2022 in Database by gaurav
• 23,260 points
1,517 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,020 points
3,378 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
1,107 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
1,241 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,762 views
0 votes
1 answer

Excel data to table on Dashing Dashboard?

It contains a feature named "Download." The ...READ MORE

Apr 11, 2022 in Database by gaurav
• 23,260 points
949 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
1,175 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
935 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
1,175 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,690 points
1,251 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,690 points
1,104 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
1,219 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
820 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
1,308 views
0 votes
1 answer

Which SQL query is used to find Nth highest salary from a salary table

If you want to find nth Salary ...READ MORE

Feb 14, 2022 in Database by Vaani
• 7,070 points
3,188 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
773 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,690 points
922 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
943 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
680 views
0 votes
1 answer

Excel: Highlighting duplicates with exact matches

To enter the Advanced Filter dialogue box, ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,260 points
1,462 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
1,196 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,690 points
853 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
1,087 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
1,227 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
1,226 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,881 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
1,375 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
1,216 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
1,161 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
766 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
1,146 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
1,229 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,690 points
844 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,690 points
672 views