Count the cell contain a specific numbers in a range
Hi Carlo,
Tks a lot, it works great!!!
But how can I get the 2nd & 3rd values if the first one return "TRUE"
Figure out like this:-
4420940138 *山有限公司 TRUE 4420940138 *山有限公司
Hong Kong FALSE Hong Kong
廣東省*山市坦洲第一工*區 FALSE 廣東省*山市坦洲第一工*區
N/A FALSE *國 郵政編碼:
N/A FALSE 453603245
Highly appreciated for your help
Simon
"carlo" wrote:
Hi Simon
try this formula:
=AND(ISNUMBER(INT(LEFT(A1,10))),LEN(A1)9)
Where your Value is in column A
and then copy this formula down.
hth
Carlo
On Jan 30, 1:30 pm, Simon wrote:
Hi All,
wud like to figure out the value which is start with 10 digit which present
by True or False.
TRUE 4420940138 *山有限公司
FALSE Hong Kong
FALSE 廣東省*山市坦洲第一工*區
FALSE *國 郵政編碼:
FALSE 453603245
See this:-
Help!!!
Simon
|