Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if(A10="test"1,0)
In a conditional statement is there any way to use some sort of "Like"
instead of just =, !=, ? I have a column with values similar to value=10, value=12, value=50. Is there any way to count the number of occurrences of "value"? The =if(A1="value",1,0) doesn't work because its looking at the entire cell value, what I'd like is some sort of =if(A10 LIKE "value,1,0) is this possible? |
#2
|
|||
|
|||
=IF(ISNUMBER(SEARCH("value",A1)),1,0)
or =if(countif(a1,"*value*")0,1,0) You could also just use: =countif(a1:a10,"*value*") To look for value in a1:a10 or maybe... =countif(a1:a10,"value*") to count those cells that Start with "value". jpjsmith wrote: In a conditional statement is there any way to use some sort of "Like" instead of just =, !=, ? I have a column with values similar to value=10, value=12, value=50. Is there any way to count the number of occurrences of "value"? The =if(A1="value",1,0) doesn't work because its looking at the entire cell value, what I'd like is some sort of =if(A10 LIKE "value,1,0) is this possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|