Excel Functions & Formulas
How to Use MIN and MAX Functions in the Same Formula in Excel
Learn how to use MIN and MAX together in Excel to limit values, apply dynamic lookups, and control SUM outputs within defined ranges.
Read article
Author & Spreadsheet Consultant
Tasmia Rahim
268 Articles PublishedPublishing since
Tasmia Rahim holds a B.Sc in Electrical Engineering with a focus on automation and embedded systems, supporting logic-driven spreadsheet workflows. With 2 years of Excel and Google Sheets experience, she works with conditional formatting and basic automation. She is interested in using macros and ActiveX controls to simplify Excel tasks and improve usability.
Editorial Review
Articles Published by Tasmia Rahim
Articles by Tasmia Rahim 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.
Excel Functions & Formulas
How to Find the Maximum Value in Excel with Condition
Learn how to find the maximum value in Excel with conditions using MAX, MAXIFS, SUMPRODUCT, AGGREGATE, and INDEX-MATCH for advanced filtering.
Read article
Excel Functions & Formulas
How to Find the Max Value and Corresponding Cell in Excel
Learn how to find the max value and its cell address in Excel using functions like INDEX, MATCH, XLOOKUP, CELL, LET, and even VBA macros.
Read article
Excel Functions & Formulas
How to Find the Lowest Value with Criteria in Excel (5 Methods)
Learn how to find the lowest value in Excel with criteria using MIN, MINIFS, IF, SMALL, and FILTER functions, AND/OR condition filtering.
Read article
Excel Functions & Formulas
How to Use COUNTIFS with Date Range and Text in Excel
Learn how to use COUNTIFS in Excel to filter by date range and text, match partial text, count specific months, & apply dynamic date filters.
Read article
Excel Functions & Formulas
Excel COUNTIF with Multiple Criteria Across Different Columns
Learn how to use COUNTIF and COUNTIFS in Excel to apply multiple criteria across columns, handle OR logic, and count keyword occurrences.
Read article
Excel Functions & Formulas
COUNTIF to Count If Cell Contains Text from List in Excel
Learn how to use COUNTIF in Excel to count cells that contain text from a list and track how many keywords appear in each cell accurately.
Read article
Excel Functions & Formulas
Calculate Average If a Range Lies Between Two Values in Excel
Learn how to calculate the average in Excel for values between two numbers or dates using ranges, columns, and cell references effectively.
Read article
Excel Functions & Formulas
How to Find Average in Excel If Cell Contains Text (4 Ways)
Learn how to find the average in Excel if a cell contains text using exact matches, wildcards, cell references, and AVERAGEIFS for conditions.
Read article
Excel Functions & Formulas
How to Use IF Function with 3 Conditions in Excel (5 Examples)
Learn how to use the IF function with 3 conditions in Excel using nested IFs, IFS, AND/OR combinations, and functions like SUM or AVERAGE.
Read article
Excel Functions & Formulas
How to Make Yes 1 and No 0 in Excel (5 Suitable Ways)
Learn how to convert Yes to 1 and No to 0 in Excel using IF formulas, Find & Replace, Power Query, VBA macros, or Office Scripts.
Read article
Excel Functions & Formulas
How to Check If a Cell Contains Text from a List in Excel
Learn how to check if a cell contains text from a list in Excel using SEARCH, COUNTIF, XLOOKUP, INDEX, and more powerful functions.
Read article