Hi all,
Before this, i just get the number for the info that i want, like right now i need the information in column itself.
Formula that i used to get the data
=COUNTIF(Q:Q,"*"&Apple&"*") so i got 2.
I would like to get the output Like "Apple = Apple-Lemon, Papaya-Apple."
Means that, find all the data in specific column only. I want Apple, and the output will come out all the data that related to Apple.
For example:
<tbody>
</tbody>
Thanks in advanced for helping me
Amira
Before this, i just get the number for the info that i want, like right now i need the information in column itself.
Formula that i used to get the data
=COUNTIF(Q:Q,"*"&Apple&"*") so i got 2.
I would like to get the output Like "Apple = Apple-Lemon, Papaya-Apple."
Means that, find all the data in specific column only. I want Apple, and the output will come out all the data that related to Apple.
For example:
Column A Apple Lemon Papaya Orange |
Column Q Apple-Lemon Lemon-Papaya Papaya-Apple Orange-Papaya |
<tbody>
</tbody>
Thanks in advanced for helping me
Amira