Skip to main content

Posts

Showing posts with the label Advance functions

Get multiple lookup values in single cell

Randbetween3

XLOOKUP

OFFICE 365 new functions

Multiple lookup values if and textjoin

Aggregate

Syntax Reference form AGGREGATE(function_num, options, ref1, [ref2], …) Array form AGGREGATE(function_num, options, array, [k])

If array formula

Subtotal

Sumproduct part1

Offset

Maxifs

Index match

Advance dropdownlist with indirect

Sumif,countif,sumifs and countifs

Concatif

Textjoin

Exclude hidden rows sumifs