1. K

    Stop Excel being excel

    Strange title I know, soz... k so here's the thing. Say you had a list a b c d e f Now when it gets to `f` I want it to go to a1 b1 and so on so I made a lil list on a adjacent column 1 2 3 4 I'm saying to excel:- ok when you complete the first list, then CONCAT `A` & (cell ref for #1 )...

Some videos you may like

This Week's Hot Topics