Excel Magic

Fill right and have reference go down;
Fill down and have reference fo right

[MrXL]

Some great tricks there, Bob. Thanks for posting this.

[ChessInstructorSF]

Pretty cool Bob, nice trick and “thinking outside the range” oh I did it again.

[excelstar]

As always! Excel out of the Box! Regards Alfred

[JonathanExcels]

Very cool. I initially thought you were going to show the text to rows trick.