So sorry for the delay, I didn't see your comment until now. The shortcuts used were to click into cell E3 where the word "Birmingham" was located, End and Down key to get to the bottom of the list, right key to move to the next colum, then press and HOLD the Shift key whilst pressing (and releasing) the END key and the UP arrow to get to the cell with List 2. Then with the cells in that column highlighted, press and hold CTRL key and then press the letter D key.
You're amazing!! Thank you for sharing!!
Really great video very good understanding concepts and explained in a very simple way love it.. 😎
Glad you liked it!
What was that nifty shortcut you used at 2:30. That was magic!!!!!
Wish there was a shortcut to get to the point.
So sorry for the delay, I didn't see your comment until now.
The shortcuts used were to click into cell E3 where the word "Birmingham" was located, End and Down key to get to the bottom of the list, right key to move to the next colum, then press and HOLD the Shift key whilst pressing (and releasing) the END key and the UP arrow to get to the cell with List 2. Then with the cells in that column highlighted, press and hold CTRL key and then press the letter D key.
@@garethcthomashow Thank you!!!
List 2 generates from no where
right?! i can't get mine to do that