Most voted questions in Database

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,580 points
2,209 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,580 points
9,576 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,580 points
1,325 views
0 votes
1 answer

Convert Number to Words in Excel VBA code

1. Prevent the conversion of the cents ...READ MORE

Dec 30, 2022 in Database by bobh

edited Mar 5 45,247 views
0 votes
1 answer

Are there such things as variables within an Excel formula?

Yes. However, not directly. a less complicated method You ...READ MORE

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

Excel COUNTIF with multiple criteria and both row and column

Count Cells Based On Text Value Using ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,580 points
2,718 views
0 votes
1 answer

Excel Remove Decimal Places

1) E2 is the cell from which ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,580 points
28,552 views
0 votes
1 answer

Number of elements in a single dimension variant array in excel

You must do UBound - LBound + ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,580 points
1,112 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,580 points
2,529 views
0 votes
1 answer

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

That's a great question, and it's a ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,580 points
2,887 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,580 points
2,571 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,580 points
1,719 views
0 votes
1 answer

Converting a large XML file to Excel

Using the web URL, import an XML ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,580 points
3,386 views
0 votes
1 answer

Excel Reference To Current Cell

Create a formula with the name THIS ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,580 points
11,572 views
0 votes
0 answers

Excel PERCENTRANK.INC in Javascript

Is there a way to get the ...READ MORE

Mar 23, 2022 in Database by Edureka
• 13,690 points
662 views
0 votes
1 answer

How to read a .xlsx file using the pandas Library in iPython?

Every sheet gets its own DataFrame, which ...READ MORE

Mar 25, 2022 in Database by anonymous
1,013 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,580 points
1,684 views
0 votes
1 answer

how do I calculate discount with if function in excel

Notes about the release; Frameworks to aim ...READ MORE

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

How to get the "Name Box" name of an Excel cell?

By typing in the Name Box, you ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,580 points
6,547 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,580 points
2,958 views
0 votes
1 answer

Excel 2003 - Match Column A with Column B & Column C to correspond to Column B

Write a standard IF formula that compares ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,580 points
3,601 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,580 points
961 views
0 votes
0 answers

Remove duplicates within a row

How do I remove duplicates within a ...READ MORE

Mar 11, 2022 in Database by Edureka
• 13,690 points

edited Mar 4 144 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,580 points
14,776 views
0 votes
1 answer

Sigma or Summation function in Excel

The SUM function in Excel is another ...READ MORE

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

How to Export Tally Data programmatically to CSV or Excel format

Open data (Ledger/P&L or Balance Sheet) that ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,580 points
3,497 views
0 votes
1 answer

How to count distinct values in Excel

Use functions to count the number of ...READ MORE

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

Excel VBA - exit for loop

When we need to depart the For ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,580 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,580 points
2,166 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,690 points
1,818 views
0 votes
1 answer

Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

We can read excel more easily with ...READ MORE

Mar 14, 2022 in Database by gaurav
• 23,580 points
5,063 views
0 votes
1 answer

Importing notepad data to excel (difficult split)

Excel: How to Use It On the Data ...READ MORE

Mar 14, 2022 in Database by gaurav
• 23,580 points
954 views
0 votes
1 answer

MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE

Mar 14, 2022 in Database by gaurav
• 23,580 points
979 views
0 votes
0 answers

How to change column datatype in SQL database without losing data?

I have a SQL Server database, and ...READ MORE

Feb 25, 2022 in Database by Vaani
• 7,070 points
962 views
0 votes
0 answers

What's the difference between a temp table and table variable in SQL Server?

We can build temp tables in SQL ...READ MORE

Feb 25, 2022 in Database by Vaani
• 7,070 points
893 views
0 votes
0 answers

Order Of Execution of the SQL query

I'm not sure what sequence this query ...READ MORE

Feb 25, 2022 in Database by Vaani
• 7,070 points
1,071 views
0 votes
0 answers

SELECT.... WHERE... OR

Is there a method to choose data ...READ MORE

Feb 25, 2022 in Database by Vaani
• 7,070 points
611 views
0 votes
0 answers

Select .... where .... OR?

Is there a method to choose data ...READ MORE

Feb 24, 2022 in Database by Hemant
• 140 points
525 views
0 votes
0 answers

Testing question and answer

This category discusses everything related to SQL/ ...READ MORE

Feb 24, 2022 in Database by anonymous
• 140 points
593 views
0 votes
0 answers

Duckworth-Lewis-Stern calculator to calculate the revised target

With the Cricket World Cup going on, ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,690 points
915 views
0 votes
0 answers

If Cell Starts with Text String... Formula

I have formula that checks if the ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,690 points
1,800 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Let's say you have a file named input.json which ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,690 points
1,103 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,690 points
2,517 views
0 votes
1 answer

Rename column SQL Server 2008

Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE

Feb 23, 2022 in Database by Vaani
• 7,070 points
1,029 views
0 votes
0 answers

How Stuff and 'For Xml Path' work in SQL Server?

Table is: Id Firstname 4 abc 4 def 4 ghi 4 jkl 4 mno Required output: Id Name 4 abc,def,ghi,jkl,mno Query: SELECT ID, ...READ MORE

Feb 23, 2022 in Database by Neha
• 9,020 points
6,447 views
0 votes
1 answer

How to calculate age (in years) based on Date of Birth and getDate()

Following can be a solution to your ...READ MORE

Feb 23, 2022 in Database by Vaani
• 7,070 points
1,992 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
• 7,070 points
15,039 views
0 votes
1 answer

Converting HTML to Excel? [closed]

Upload html-file(s) Select files from Computer, Google ...READ MORE

Feb 23, 2022 in Database by gaurav
• 23,580 points
897 views
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

Feb 23, 2022 in Database by gaurav
• 23,580 points
12,238 views