Excel: Return Multiple Rows with No Row Gaps (combo box)
Posted on 2014-04-15
Not sure if this is possible.
I have the following dataset on two separate rows. The first column is a combination box.
[yes/no] Sentence 1
[yes/no] Sentence 2
[yes/no] Sentence 3
[yes/no] Sentence 4
I have a further 4 rows where I would like to display only the sentences with [yes] next to them. I would like there to be no row gaps between the sentences. E.g:
(above example is if [yes] = sentence 1 & 3 - note there is no 'blank row' between the sentences, they appear one row after the other)
Hopefully I explained this ok.
What's the best way of getting this to work?