Hello everyone
I'm looking a way to the following, I have a huge sheet1 like this:
sheet1
quantity | reference | item
7 | 6190221 | item1
| 3443220 | item2
| 7244163 | item3
3 | 8900167 | item4
| 3638812 | item5
And I have a sheet2 that currently shows the same because is done this way
=IF(ISTEXT("sheet1".A6);"sheet1".A6;""), but since sheet1 is growing
steadily, and data changes quite often I need to keep sheet2 clean showing
only items with quantity, what I expect is this:
sheet2
quantity | reference | item
7 | 6190221 | item1
3 | 8900167 | item4
How I can do this with functions?
Thanks.
--
View this message in context:
http://www.nabble.com/Filtering-Openoffice-Calc-tp21266033p21266033.html
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
