Excel Magic Trick 1460

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


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.


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

Be the first to comment

Leave a Reply