Microsoft Excel Puzzle and Solutions.
Bob Umlas sent in the puzzle. How to refer to every 3rd column on Sheet2?
Table of Contents
(0:00) Bob Umlas Book
(0:22) Problem: Refer to every 3rd cell
(0:44) CHOOSECOLS with SEQUENCE
(1:16) Horizontal XLOOKUP
(1:46) Fill Handle from 3 Cells
(2:32) Delete Empty Cells
(2:54) R1C1 Method 2
(3:43) Replace = with x=
(4:12) Change R1C1 to A1
(4:21) Insert colums/rows to test