View Single Post
  #1   Report Post  
Janwillem
 
Posts: n/a
Default IS this possible?

Hi there. I have the following in Excel:


A B C D
1 hello 1
2 test 0
3 bye 1
4 hi 0
5 bybye 0
6 tjou 2


now on another place in this sheet i want to see all the words under each
other where the B value is bigger the 0 so:

E F G

1 hello
2 bye
3 tjou


So i only want to show th'ose words that have a bigger value. and i don't
want whitelines between the words like this ( =IF(B10,A1,"") )


E F G
1 hello
2
3 bye
4
5
6 tjou