Excel Magic Trick 1205


Rearrange Data with INDEX Function & Formula Number Incrementers

DESCRIPTION

See how to Rearrange Data With INDEX Function & Formula Number Incrementers:
(00:00) Problem Setup.
(01:57) Formula Number Incrementer to generate the pattern: 1,1,2,2,3,3… or 1,1,1,2,2,2,3,3,3…
(04:23) Formula Number Incrementer to generate the pattern: 1,2,1,2,1,2… or 1,2,3,1,2,3,1,2,3…
(05:40) How to use INDEX and Formula Number Incrementers to rearrange data from a two way table.
(07:03) How to use INDEX and Formula Number Incrementers to rearrange data from a two separate columns.
(11:03) Summary

WORKBOOKS




Be the first to comment

Leave a Reply