is it possible to sort or find the lines that have a particular word (in a specific column)?
for example, I have a column titled part#, I want to find all part # with the word "unit" in them. Unfortunately the word Unit is somewhere in the middle of the text
thanks!
Last edited by brotherwo; 03-10-2011 at 05:58 PM.
=isnumber(Search("Unit",A2))
copied down in a new column where A2 would be first cell to look in.
TRUE means "Unit" found, then you filter or sort this column.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That works however...Originally Posted by NBVC
is it possible to return a quantity rather than true false? in column B there is quantity of 2 for a "unit", instead of true can it return 2 and if it was false return zero?
Where is the 2 coming from exactly? What do you mean there is a quantity for "unit"?
If you simply want a 2 for every cell with Unit and 0 if no unit in the cell..then:
=2*isnumber(Search("Unit",A2))
Last edited by NBVC; 03-10-2011 at 04:50 PM.
I mean there is a column with the quantity of units...so if the statment is true (it is a unit) it will return whatever quantity is in that column. However, if the statement is false I want it to return a zero
You mean something like:
=IF(isnumber(Search("Unit",A2)),B2,0)
where B2 contains the quantity?
awesome...works great!
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks