If statement in Excel looking for text

[Closed]
Report
Posts
1
Registration date
Sunday November 22, 2009
Status
Member
Last seen
November 23, 2009
-
 Conner -
I have a column with 3 text labels (book, pencil, eraser). I want to create a new column where I can find cells in the original column that have either "pencil" or "eraser".

Thanks in advance.

xmtlr

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
see whether you can do this
highlight column A (this column should heave column heading)
click date(men bar)-filer-autofilter
there will be small arrow in the column heading of column A
click that arrow
click "pencil" in download list
you will get pencil filtered. highlight the visible cells and copy anywhere
click <all> in the download box
again repeat same steps for eraser.
lastly click date-filter-autofitler
the filter will be removed.
I would try =IF(cell range="book". book, IF(cell range="pencil", pencil, IF(cellrange="eraser", eraser, none)))

That was just a quick shot, you will need to play with the parenthesis.

Hope this helps.

-Conner
http://www.oneclickcommissions.com/excel-statements.html