Complex isn't an issue as long as I can type it in correctly. If I decide at a later date to add an x to cell E5 will it automatically update the lists for me? If so then awesome. I shall try and work it out myself when I'm in work tomorrow
I'd like column C to list all the numbers that have a cell containing an x beneath them in each row.
Numbers 1 2 3 4 5 6 7 8 9 10
Adam Smith x x x x x
Bob Davies x x x
Chris Wright x x x x
David Cook x x...