Excel Magic Trick 1370

INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell

DESCRIPTION

See how to Create Formula to Extract Each Item In List & Display In Every Third Column. Topics:
(00:15) Introduction to Problem
(01:03) Formula Element Number Incrementor to create pattern like: 1,1,1,2,2,2,3,3,3… See functions COLUMNS and ROUNDUP
(04:40) INDEX Lookup Formula
(06:10) Formula Element Number Incrementor to create pattern like: 1,2,0,1,2,0,1,2,0… See functions COLUMNS and MOD Function.
(07:40) IF Function part of formula
(08:55) Summary
INDEX Function & Number Incrementor

WORKBOOKS

Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 349 times – 14 MB




Be the first to comment

Leave a Reply