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 4, 2022 in Database by gaurav
 • 23,260 points • 811 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 • 681 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, 2022 in Database by gaurav
 • 23,260 points • 814 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 • 804 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 • 1,044 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 • 659 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 • 1,165 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 • 1,021 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,243 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,690 points • 602 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,690 points • 589 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,690 points • 583 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 • 918 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,690 points • 733 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 • 869 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,690 points • 713 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 • 663 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,260 points • 1,565 views
0 votes
1 answer

What is the Oracle PL/SQL "--+rule"?

The answer is in the material you ...READ MORE

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

How to read and write excel file

When broken down into steps, reading an ...READ MORE

Mar 25, 2022 in Database by Edureka
 • 13,690 points • 1,043 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 • 912 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,703 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,690 points • 490 views
0 votes
0 answers

Check Excel file format from PowerScript not relying on file extension

We have a number of Excel files ...READ MORE

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

Calculating percentile - Excel vs online

Syntax PERCENTILE(array,k) The following are the arguments to the ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 739 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,690 points • 438 views
0 votes
0 answers

in MS excel find first non n/a value in row

I have dates (Jan-2014 in cell A1, ...READ MORE

Mar 30, 2022 in Database by Edureka
 • 13,690 points • 711 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,260 points • 922 views
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 2,154 views
0 votes
1 answer

SQL Server: PARTITION BY vs GROUP BY

To understand the differences between GROUP BY ...READ MORE

Feb 9, 2022 in Database by Neha
 • 9,020 points • 2,725 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,260 points • 855 views
0 votes
1 answer

How to read and write excel file

When broken down into steps, reading an ...READ MORE

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

Retrieving Cell name in Excel

ADDRESS(ROW(),COLUMN()) returns the current cell's address, such ...READ MORE

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

Change default 'delimiters' in excel

Select a non-empty cell. Do Data -> Text ...READ MORE

Feb 21, 2022 in Database by gaurav
 • 23,260 points • 2,101 views
0 votes
1 answer

Conditional Sum in Excel that counts values above X as X

B1 formula is: =SUMIF(A1:A5,"<=5") +COUNTIF(A1:A5,">5") *5 Fill in the blanks ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 515 views
0 votes
0 answers

Count colored cell on excel automatically

I'm trying to count the number of ...READ MORE

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

Insert into ... values ( SELECT ... FROM ... )

Try: INSERT INTO tableA ( column_1 ) SELECT ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,020 points • 1,908 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,658 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,260 points • 538 views
0 votes
0 answers

Customization of mysql log file

Hi , In mysql general log file we ...READ MORE

Apr 5, 2022 in Database by anonymous
edited Mar 4 • 35 views
0 votes
0 answers

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

I spent hours trying to debug this. ...READ MORE

Apr 5, 2022 in Database by Edureka
 • 13,690 points
edited Mar 4 • 31 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,757 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,260 points • 999 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 1,726 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 • 537 views
0 votes
1 answer

What is the definition of cardinality in SQL?

Cardinality is defined as the "number of ...READ MORE

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

How do I perform an IF THEN statement in an SQL SELECT?

The CASE statement is the closest to IF in ...READ MORE

Feb 16, 2022 in Database by Vaani
 • 7,070 points • 1,876 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,260 points • 779 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,260 points • 798 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.