Excel Pro Tips
How to Randomly Select from a List in Excel (5 Useful Ways)
Learn how to randomly select from a list in Excel using Data Analysis, INDEX with RANDBETWEEN, RANDARRAY, RAND, and custom VBA macros.
Read article
Blog
1285 articles
Google Sheets Functions
How to Do a Reverse VLOOKUP in Google Sheets (5 Examples)
Learn how to do a reverse VLOOKUP in Google Sheets using INDEX-MATCH, ARRAYFORMULA, FILTER, and QUERY for flexible and dynamic lookups.
Read article
Google Sheets Functions
Google Sheets COUNTIF to Check If a Cell Contains Text
Learn how to use COUNTIF in Google Sheets to check if a cell contains text, matches specific words, or excludes certain text entries.
Read article
Excel Pro Tips
How to Return Multiple Values Based on Single Criteria in Excel
Learn how to return multiple values based on single criteria in Excel using FILTER, INDEX, TEXTJOIN, Power Query, and custom VBA macros.
Read article
Excel Pro Tips
How to Return Row Number of Match in Excel (8 Suitable Ways)
Learn how to return the row number of a match in Excel using ROW, MATCH, INDEX, IF, TEXTJOIN, and VBA for single or multiple matches.
Read article
Excel Pro Tips
How to Put Comma Between Numbers in Excel (5 Simple Ways)
Learn how to insert commas in numbers in Excel with custom formatting, TEXT function, conditional IF, string functions &Comma Style button.
Read article
Excel Functions & Formulas
How to Use SUMIFS with Date Range and Multiple Criteria in Excel
Learn how to use SUMIFS in Excel with a date range and multiple criteria using TODAY, DATE functions, and dynamic filters.
Read article
![[Solved] CONCATENATE Function in Excel Not Working](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-concatenate-excel-not-working-01f51cea.webp)
Excel Pro Tips
[Solved] CONCATENATE Function in Excel Not Working
Learn why the CONCATENATE function in Excel may not work—due to text formatting, formula display mode, range issues, or using CONCAT instead.
Read article
Excel Pro Tips
How to Convert Radians to Degrees in Excel (3 Easy Methods)
Learn how to convert radians to degrees in Excel using the DEGREES function, a manual PI-based formula, or a simple VBA macro.
Read article
Google Sheets Functions
How to Use COUNTIF to Count Non-Blank Cells in Google Sheets
Learn how to use COUNTIF in Google Sheets to count non-blank cells, even across ranges, while ignoring specific values and extra spaces.
Read article
Excel Functions & Formulas
How to Use SUMIFS Function in Excel with Multiple Sheets
Learn how to use the SUMIFS function in Excel with multiple sheets by combining it with SUMPRODUCT, INDIRECT, and the plus (+) operator.
Read article
Excel Functions & Formulas
SUMIFS with Multiple Criteria in Same Column in Excel
Learn how to use SUMIFS with multiple criteria in the same column in Excel by combining conditions, using SUMPRODUCT & optimizing formulas.
Read article