Get
Digital
Help
More
  • Home
  • Functions
    Functions A to Z Functions by category
  • Formulas
  • Features
    Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
  • Archive
    All articles Products
  • Contact
    About me Blogs I read
    Formula categories
    #
    2D
    3D
    365
    Address
    Alternative
    And logic
    Autofilter
    Average
    Blank
    Calendar
    Case
    Character
    Column
    Combination
    Complex
    Concatenate
    Conditional formatting
    Count
    Countif
    Countifs
    Criteria
    Date
    Day
    Decimal
    Delete
    Digit
    Dynamic
    Empty
    Equal
    Error
    Extend
    Extract
    Finance
    First
    Group
    Hour
    Hyperlink
    If
    Ifs
    Ignore
    Image
    Index
    Index match
    Intersection
    Lambda
    Large
    Letter
    Lookup
    Match
    Max
    Min
    Minute
    Month
    Multiply
    Negative
    New line
    Not equal
    Or logic
    Overlapping
    Partial
    Permut
    Random
    Rearrange
    Record
    Recursive
    Reference
    Relation
    Reverse
    Right
    Running total
    Schedule
    Second
    Sequence
    Shared
    Small
    Solver
    Sort
    Split
    String
    Substitute
    Subtotal
    Sum
    Sumif
    Sumifs
    Sumproduct
    Tab
    Table
    Team
    Text
    Time
    Unique
    Vlookup
    Week
    Year



'Case sensitive' category



test
INDEX MATCH – Case sensitive
The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]
test
Case sensitive lookup and return multiple values
The array formula in cell F5 returns adjacent values from column C where values in column B matches the search […]
test
Count unique distinct values
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories


Home page
Excel Functions
Excel Formulas
Excel Tables
Advanced Filter
Data Validation
Drop Down List
Named Ranges
Excel Solver
Charts
Conditonal Formatting
Pivot Tables
VBA
Macros
UDFs
Archive

      • Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup

  • Search website

Privacy PolicyNo AI