Thread
:
Formula for searching for a text string
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Formula for searching for a text string
assumes gen is at the end??
helper column
=IF(AND(E2<"",RIGHT(E2,3)<"gen"),1,0)
without helper column
=SUMPRODUCT((LEN(E2:E22)2)*(RIGHT(E2:E22,3)<"gen "))
--
Don Guillett
SalesAid Software
"KellyB" wrote in message
...
I have a table where each cell contains a string of various alphanumeric
codes. For example:
KB / S596-19
RM / S243-59
VB
/ I1997-1
KB / GEN
SV / GEN
I want to write a formula to count 1 if the cell is populated (not all
cells
are), but count 0 if the cell contains 'GEN'.
I've tried this:
=IF(AND(B4<"",B4<"*GEN*"),1,0)
But the "*GEN*" portion of this formula does not work.
Any suggestions?
KellyB
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett