How to Count cells equal to either X or Y With COUNTIF?
To count the cells, equal to either X or Y, we can basically use the function of…
We found 0 articles by this author...
How to know the number of the first column in the range?
To know the number of the first column in the range, all you have to do is…
How to Count visible rows in a filtered list using SUBTOTAL formula?
To count the number of rows that are visible to the naked eye regarding particular data, you can follow the SUBTOTAL Function.
How to get decimal part of a number using TRUNC Formula?
To get the decimal part of the number, here’s what you can do:
How to count the missing values using COUNTIF function?
When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing.
How to split the texts and numbers Using Flash Fill in Excel?
To split the texts and numbers which are present in one cell together, it’s an easy job.
How to calculate the remaining days in 2 simple steps?
If you are looking forward to a formula where you can calculate the no. of days remaining in your project/ work etc. you have come at the right place.
How to sort data in ascending or descending order?
When you are managing a lot of data entries in excel, a time comes when you have to arrange or sort the data in ascending or descending order.
How to Convert date to month and year using TEXT Formula?
At times we require our data to be in the format of month & year and not in the format of the actual date.