Ankita Jain
New Member
Hi All,
I have a data table which looks like this:
I want to select all "no" (row 3, 5, 6) from yes/no column and add into another table without leaving any blank spaces. The output should be like this:
A B C D
1 yes/no Data1 Data2 Data3
2 no abcd2 abcd3 abcd4
3 no abcd5 abcd6 abcd7
4 no abcd8 abcd9 abcd10
Please help me out to create a formula in excel and achieve this dynamically. It's not necessary that "no" should always be present in Row(3), Row(5) and Row(6).
Thank You..!!
I have a data table which looks like this:
Code:
A B C D
1 yes/no Data1 Data2 Data3
2 yes abcd1
3 no abcd2 abcd3 abcd4
4 yes
5 no abcd5 abcd6 abcd7
6 no abcd8 abcd9 abcd10
7 yes
8 yes
I want to select all "no" (row 3, 5, 6) from yes/no column and add into another table without leaving any blank spaces. The output should be like this:
A B C D
1 yes/no Data1 Data2 Data3
2 no abcd2 abcd3 abcd4
3 no abcd5 abcd6 abcd7
4 no abcd8 abcd9 abcd10
Please help me out to create a formula in excel and achieve this dynamically. It's not necessary that "no" should always be present in Row(3), Row(5) and Row(6).
Thank You..!!