Google Sheets Intermediate Tutorials
How to Filter with Multiple Conditions in Google Sheets
Learn how to filter with multiple conditions in Google Sheets using FILTER and QUERY functions, combining AND, OR, text, and numeric logic.
Read article
Author & Spreadsheet Consultant
Tahmid Munim
16 Articles PublishedPublishing since
Tahmid Munim Hossain is completing a Master’s in Biochemistry and Molecular Biology at the University of Dhaka. With 4+ years of experience in Excel and Google Sheets, he specializes in data cleaning, transformation, advanced formulas, workflow automation, and report building. Tahmid has optimized spreadsheets for SEO, client reporting, and performance tracking. He also applies spreadsheet-based analysis in molecular diagnostics and genomic research. His interest lies in using spreadsheets as a tool for biological and genomic data analysis.
Editorial Review
Articles Published by Tahmid Munim
Articles by Tahmid Munim are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Google Sheets Functions
How to Use IMPORTRANGE in Google Sheets with Conditions
Learn how to use IMPORTRANGE in Google Sheets with conditions by combining it with QUERY, FILTER, helper columns, and multiple criteria.
Read article
Google Sheets Functions
How to Count Unique Values in Google Sheets (5 Simple Ways)
Learn how to count unique values in Google Sheets using COUNTUNIQUE, UNIQUE with COUNTA, COUNTIF, SUMPRODUCT, and FLATTEN for advanced cases.
Read article
Google Sheets Functions
How to Count Non-Empty Cells in Google Sheets
Learn how to count non-empty cells in Google Sheets using COUNTA, COUNTIF, and ARRAYFORMULA while filtering spaces and applying conditions.
Read article
Google Sheets Formulas
How to Remove Duplicates with Formula in Google Sheets
Learn how to remove duplicates in Google Sheets using formulas like UNIQUE, FILTER, QUERY, ARRAYFORMULA, and MATCH for dynamic data cleanup.
Read article
Google Sheets Formulas
How to Get the Weekday Name from a Date in Google Sheets
Learn how to get weekday names from dates in Google Sheets using TEXT, WEEKDAY, CHOOSE, SWITCH, ARRAYFORMULA, and Apps Script methods.
Read article
Google Sheets Formulas
Automatically Copy Data from Another Worksheet in Google Sheets
Learn 6 easy ways to automatically copy data from one sheet to another in Google Sheets using formulas, QUERY, scripts, and more.
Read article
Google Sheets Functions
How to Use COUNTIF to Count TRUE in Google Sheets
Learn how to use COUNTIF, ARRAYFORMULA, SUMPRODUCT, and more to count TRUE values effectively in Google Sheets with flexible methods.
Read article
Google Sheets Basics
How to Sort Columns in Google Sheets without Mixing Data
Learn how to sort columns in Google Sheets without mixing data using Sort Range, SORT function, QUERY, filters, and Apps Script.
Read article
Google Sheets Functions
How to Use VLOOKUP to Return Multiple Values in Google Sheets
Learn how to use VLOOKUP for multiple values in Google Sheets with FILTER, TEXTJOIN, QUERY, ARRAYFORMULA, and Apps Script alternatives.
Read article
Google Sheets Intermediate Tutorials
How to Filter Duplicates in Google Sheets (4 Easy Methods)
Learn how to filter duplicates in Google Sheets using FILTER with COUNTIF, UNIQUE, conditional formatting, or Google Apps Script.
Read article
Google Sheets Basics
How to Remove Hyperlinks in Google Sheets (5 Easy Ways)
Learn how to remove hyperlinks in Google Sheets using the context menu, link preview, formulas, paste special, or Apps Script.
Read article