Excel Magic Trick 1460

List All Relative Positions in a Single Cell using TEXTJOIN Array Formula

DESCRIPTION

Learn how to look up an item in a list of items and list all the relative positions for that item in a single cell. See the functions TEXTJOIN, IF, ISNA, MATCH. See extensive discussion about Array Formulas. Learn different Formula Element options for listing all relative positions in a formula.

WORKBOOKS

Download “Excel Magic Trick 1455-1460” Excel-Magic-Trick-1455-1460.zip – Downloaded 30 times – 5 MB







Be the first to comment

Leave a Reply