Hi folks,
I have a column of data as follows:
ab10 5 for sale
ab20 0 for sale
ab30 0 for sale
ab30 3 for sale
ab40 0 for sale
ab30 19 for sale
ab40 4 for sale
Any item that is ab30 or ab40 is no longer fit for purpose, but some still have items for sale. So, what I need is a formula that looks to see if a text string starts with either ab30 or ab40 and if it has 0 for sale it should return "REMOVE". If the value is greater than 0 than "USE UP". However, anything that is ab10 or ab20 should be "GOOD".
So, the results should be:
ab10 5 for sale GOOD
ab20 0 for sale GOOD
ab30 0 for sale REMOVE
ab30 3 for sale USE UP
ab40 0 for sale REMOVE
ab30 19 for sale USE UP
ab40 4 for sale USE UP
Any ideas!?
SA
Bookmarks