Count Unique Values Regardless of Capitalization – Google Sheets
Count unique values in a spreadsheet while ignoring capitalization.
Tutorials
Count With OR Logic in Google Sheets
Count cells based on several conditions
3 Google Sheets Formulas for No-Code App Builders
Learn three must-know formulas for no code app builders.
Count Rows With OR Condition in Two Columns- Google Sheets
Count cells based on values in two columns
Hide Data Using IMPORTRANGE in Google Sheets
Spreadsheets users often need to hide data in their spreadsheets. Let’s say you have a file with employee pay details, and only personnel in the human resources department are allowed to see it. However, the accounting department needs to access summarized data. We will walk through a scenario where one user can see the detail … Read more