WERNER SLABBERT
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 104
hi all
i can't remember that formula where it looks for one word or phrase and then returns everything in the columns next to that.
in other words.
i have 5 colums with text and numbers in them in the last column stock movem,ent is indicated with either a z for dead or a range of other letters indicating it's status.
what i need to do is have the formula look at the whole sheet ( bloody long one ) and return on another sheet only the rows with a z* in the last column...
any and all help appreciated.
i can't remember that formula where it looks for one word or phrase and then returns everything in the columns next to that.
in other words.
i have 5 colums with text and numbers in them in the last column stock movem,ent is indicated with either a z for dead or a range of other letters indicating it's status.
what i need to do is have the formula look at the whole sheet ( bloody long one ) and return on another sheet only the rows with a z* in the last column...
any and all help appreciated.