Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |