Hosne Ara

In the following overview image all the formulas are displayed in the sheet.   This is the sample dataset containing Employee Name, Basic ...

Method 1 - Applying Excel MAX Formula to Find Maximum Value in Range Steps: Type the below formula in Cell B15 and press Enter from the keyboard. ...

ADD Method 1 - Use an Empty Cell as Reference to Add a Blank Option in a Drop-Down List Insert a Blank Cell: Begin by adding an empty cell at the ...

Dataset Overview We'll use the list of dates below to convert to year. Method 1 - Convert Date to Year Using Excel YEAR Function Open your ...

Let’s consider a dataset containing area-wise sales data of several fruits. We will create a Data Validation drop-down list of areas mentioned in the dataset ...

We have a sample dataset containing several fruits and their corresponding fruit types. We'll calculate the number of rows from column B that contain fruits ...

Let’s consider a dataset (B5:D10) containing fruit names in two columns (columns B and C). We will compare fruit names between these columns and return TRUE or ...

Method 1 - Select All Cells with Values Using the ‘Go To Special’ Command The dataset below has data on several areas of fruit sales date-wise. However, it ...

We have a data range (B4:E12) that contains sales data for several electronic products (Date-wise). You can delete blank cells manually by selecting them one ...

What is Advanced Filter in Excel? Most of us are familiar with the regular Filter option in Excel. However, the regular Filter has some limitations. For ...

  What is Reference (#REF!) Error in Excel? The reference (#REF!) error is usually displayed when a cell referred to in the Excel formula is not valid. ...

Method 1 - Delete Rows Based on Another List by Applying the Excel COUNTIF Function and Sort Option Steps: Type the below formula in Cell D5 (on the ...

We used a simple subtraction formula to get the difference between time data. The formula we have used is: =C5-B5 Reason 1 - Excel Returns ...

Usually, we can use the COUNTA function to get the count of existing rows in a dataset. However, when rows are hidden manually or through applying the Filter ...

  Method 1 – Using the Paste Option to Copy Formulas from One Workbook And Paste to Another Steps: Go to Book1 and copy the data (E5:E10) using ...