请求有关多个范围的公式语法的帮助
背景:年份(0到5)有进程(1到25)，每个进程有角色(1到10)。在附带的图像中，我在Test_A1中添加了一个公式，该公式应该每年检查所有角色/流程，以确定它在整个一年中是否唯一(仅使用一次)。
我已经有一个Excel文件的范围，所以要确保:
- 原样语法将检查前两个范围
- 我如何修改它来添加每个额外的范围?举个例子就好了!
答案
-
Intern98 ✭✭✭你好，A1中的公式不会检查角色是否为年度唯一条目。
将“OR”替换为“AND”将有助于识别范围内是否存在重复。
帮助文章参考资料欧宝体育app官方888
=COUNTM(COLLECT({Action Plan Notes}, {RR Type}, @cell = \"Backlog\")) \/ COUNTIFS({RR Type}, @cell = \"Backlog\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106826,"type":"question","name":"VLOOKUP Help","excerpt":"I am trying to bring data in from another source sheet. This source sheet is updated as users submit forms. So when a user submits a form with new data, a new top row is created on the source sheet. I would like it to auto update my master tracking sheet. Is this possible with vlookup? The issue is I need it to be specific…","categoryID":322,"dateInserted":"2023-06-23T13:49:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T18:47:22+00:00","insertUserID":162593,"insertUser":{"userID":162593,"name":"BMiller828","url":"https:\/\/community.smartsheet.com\/profile\/BMiller828","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T18:46:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162593,"lastUser":{"userID":162593,"name":"BMiller828","url":"https:\/\/community.smartsheet.com\/profile\/BMiller828","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T18:46:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":23,"score":null,"hot":3375077809,"url":"https:\/\/community.smartsheet.com\/discussion\/106826\/vlookup-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106826\/vlookup-help","format":"Rich","lastPost":{"discussionID":106826,"commentID":382069,"name":"Re: VLOOKUP Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382069#Comment_382069","dateInserted":"2023-06-23T18:47:22+00:00","insertUserID":162593,"insertUser":{"userID":162593,"name":"BMiller828","url":"https:\/\/community.smartsheet.com\/profile\/BMiller828","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T18:46:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2LDFCKZXOAMX\/screenshot-2023-06-23-094316.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-23 094316.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T18:47:08+00:00","dateAnswered":"2023-06-23T16:44:05+00:00","acceptedAnswers":[{"commentID":382023,"body":"
Make sure you are following the appropriate steps for creating cross sheet references.<\/p>
<\/p>
