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

    VB for Applications


    Functions

    Array

    Fix

    Int

    Join

    Sgn

    Split

    Vba

    Lookup and reference

    Combo boxes

    Methods

    Evaluate

    Range.find

    Texttocolumns

    Properties

    Range.offset

    Statements

    Do loop

    For next

    Goto

    If then else elseif end if

    Select case

    Set

    With end with

    VBA

    Array variables

    Dialog boxes

    Files

    List boxes

    Text boxes

    Web

    Like operator


    Macro

    Copy n-th row

    Copy from workbooks

    Non-contiguous rngs

    Select blank cells

    Quick access toolbar

    Run macro when open

    How to - Dialog boxes

    Multiply numbers in each row by entire cell range

    How to save specific multiple worksheets to a pdf file programmatically

    Find literal values in formulas

    Consecutive values

    Working with comments – VBA

    Copy filtered tables

    How to highlight row of the selected cell programmatically

    Add macro to ribbon

    Text boxes

    Show/Hide image [VBA]

    Toggle hidden sheets

    Toggle hidden column

    Scroll bar

    Date ranges overlap

    Count text string in all formulas in a worksheet [VBA]

    Locate a shape in a workbook

    Working with FILES

    Change a pic

    Move a shape [VBA]

    Macro - Dropdown

    Hide specific columns

    Copy worksheets in active workbook to new workbooks

    Copy table criteria

    Excel calendar

    Extract cell references

    Sort cell delimiter [VBA]

    Quickly create sheets

    Click to select series

    Sort Excel table [VBA]

    Split values

    Search related tables

    Create comment if cell value is larger than column

    Select a cell

    Getting things done

    Normalize data [VBA]

    Add values to sheets

    Add values to table

    Add value to drop down

    Open Excel files

    Button on/off macro

    Automate data entry

    Data validation list

    Log WB activities

    Auto resize columns

    Copy expanding range

    List open workbooks

    Basic data entry [VBA]

    List Excel tables

    Comboboxes

    Drop down list

    Filter Excel Table

    Populate combobox (2)

    Drop-down list [VBA]

    Filter Table [VBA]

    Populate listbox(2)

    Populate combobox

    Add item - context menu

    Select A1 on all sheets

    Save to Add-In

    Group text / Text-to-cols

    Create a Print button

    Select/View invoice

    Populate listbox

    Edit invoice data [VBA]

    Save invoice data – VBA

    Consolidate sheets

    Rearrange data

    Split data across sheets

    Schedule calendar

    Unique dist. list

    Missing numbers


    User defined function

    Text between words

    Search for file in folders

    Split strings & search

    Comma separated vals

    Count cell color

    Replace text strings

    Lookup merged values

    Display vals based rng

    Extract filtered table

    Rearrange data

    Two-way lookup

    SUMIF across sheets

    List files in folders

    Save to Add-In

    Uniq. dist. case sens.

    Word frequency [UDF]

    No net close to zero

    Find numbers in sum

    Permut w/o repetition

    Permut with repetition

    Values not shared

    Shared values

    Extract duplicate values

    Count unique dist. vals

    Unique strings [UDF]

    Unique distinct strings

    Split duplicate strings

    Split strings

    Group values equally


    Files and folders

    Copy from workbooks

    Search for file in folders

    Edit file names

    Unzip files

    Filter duplicate files

    Compare file names

    Search workbooks(1)

    Move data to workbooks

    Search workbooks(0)

    File passw. protected

    Working with FILES

    Filename hyperlinks

    Open Excel files

    List files in folders


    Check boxes

    Multi-level To-Do list

    Open Excel files

    Button on/off macro

    Copy checkboxes 2/2

    Add checkboxes 1/2

    Sum using checkboxes




'User Defined Function' category



test
Search for a file in folder and subfolders – UDF
Table of Contents Search for a file in folder and sub folders - User Defined Function Search for a file […]
test
Extract unique distinct values from an Excel Table filtered list
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]

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

  • Search website

Privacy PolicyNo AI