I have a column in a spreadsheet that reads True or False. I would like to make a formula that would take the false statements in that column and put them into another table. Also, if it would be possible for excel to tell me which rows that the false statement is present.

Any help is greatly appreciated.

Thanks,