How to Get Value From Every Nth Row?
June 25, 2021
In this article, I will show you how to get value from every nth row using a formula. With this formula, retrieving alternating values is no longer a draining task.
How to get distinct values in Excel? (6 ways)
April 19, 2021
I will show you 6 different ways to get distinct values in Excel. “Remove duplicates”, “Advanced filter”, “Function”, “Formula”, “Pivot table” and “VBA”.
How to highlight cells that equal multiple values in Excel?
April 5, 2021
Basic conditional formatting allow us to highlight value equal to one value at a time. Here I will show you how to highlight cells equal to more than one value.
How To Remove Digits After Decimal In Excel?
March 30, 2021
In this article, I will show you three ways to delete number after decimal points in Excel.
How to use REPT functions to the Most
February 2, 2021
Repeat a set of character Formula of Cell C2 =REPT(A2,B2) =REPT(character to repeat, the number of times you would like it to repeat) This is the most common usage of REPT. Specify the character to repeat and the number of
2021 New Year Resolution List for Excel
January 26, 2021
Time to think about what to learn in Excel for 2021? We lay out 6 goals, divided by your level of expertise on what we think are great goals to further yourself in Excel!
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
