Excel:数字0-9或逗号分隔值0-9的自定义数据验证 [英] Excel: Custom Data Validation for numbers 0-9 or comma separated values 0-9

问题描述

我在以下方面提出了类似的问题: Excel:如何确保单元格包含数字1-6或逗号分隔的数字1-6?

I had asked a similar question in: Excel: how ensure cells contain numbers 1-6 or comma separated numbers 1-6?

JvdV给了我一个很好的答案，并给出了1-6或逗号分隔的公式.

JvdV gave me a great answer and formula for numbers 1-6 or comma separated.

=IFERROR(FILTERXML("<t><s>"&SUBSTITUTE(A1,",","</s><s>")&"</s></t>","//s[preceding::*=.  or .*0!=0 or .*1>6 or .*1<1]"),"")=""

我本来以为修改起来会很容易，但是显然，我不理解语法.什么是语法，仅允许数字0-9或那些值用逗号分隔?

I would have thought it would be easy to modify but obviously, I don't understand the syntax. What is the syntax to allow only the numbers 0-9 or those values separated by commas?

推荐答案

尝试:

=IFERROR(FILTERXML("<t><s>"&SUBSTITUTE(A1,",","</s><s>")&"</s></t>","//s[preceding::*=.  or .*0!=0 or .*1>9 or .*1<0]"),"")=""

这篇关于Excel:数字0-9或逗号分隔值0-9的自定义数据验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！