# AutoCat multiple-match criteria -- maximum recommended per row? (or max rows?)

**URL:** <https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116>\
**Category:** Google Sheets\
**Tags:** google-sheets, autocat\
**Created:** [March 20, 2022, 3:31pm UTC](https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116 "2022-03-20T15:31:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![GeorgeKao](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/georgekao/32/8871_2.png) [@GeorgeKao](https://community.tiller.com/u/GeorgeKao)\
**Post date:** [March 20, 2022, 3:31pm UTC](https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116/1 "2022-03-20T15:31:42Z")

</div>

Great to learn about AutoCat’s multiple-match criteria feature. Example: categorizing multiple restaurants in one Autocat row, with description looking like this:

_“China North Dumpling”,“Fujiyamaya San Franciscoca”,“A Desi Cafe”_

**Now I wonder what would be the maximum recommended per row?**

Or is it better for performance (speed of processing) to reduce the use of multi-criteria, and instead put them into separate rows? If so, what’s the maximum recommended number of of rows for Autocat?

Thank you. I’m enjoying Tiller!

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [March 22, 2022, 12:19pm UTC](https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116/2 "2022-03-22T12:19:36Z")

</div>

Hi @GeorgeKao

Glad you’re enjoying Tiller 🙂

There isn’t really a maximum number of rules that we are aware of, but the more rows/rules you have the longer it will take to process your sheet. I’d recommend adding them all to a single row as multiple criteria and see how that goes. That would give us some feedback on whether or not at some point it maxes out 😉 but there is no limitation built into the code for max criteria in a multi-criteria rule.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [March 22, 2022, 5:23pm UTC](https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116/3 "2022-03-22T17:23:58Z")

</div>

As @heather said, I think you are pushing the limits as much as anyone, @GeorgeKao. Having written that code:

1. There is no limit on the number of match criteria.
2. I’m going to guess it is essentially a toss up performance wise.

Let us know how it goes.

Randy

---

<div class="post-metadata">

**Author:** ![GeorgeKao](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/georgekao/32/8871_2.png) [@GeorgeKao](https://community.tiller.com/u/GeorgeKao)\
**Post date:** [March 23, 2022, 1:56am UTC](https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116/4 "2022-03-23T01:56:10Z")

</div>

Great to have this response from the developer himself! Thank you @randy . Given that it’s a toss-up performance wise, it seems easier to organize by using multiple rows, instead of multi-criteria within one row?

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [March 23, 2022, 3:28am UTC](https://community.tiller.com/t/autocat-multiple-match-criteria-maximum-recommended-per-row-or-max-rows/12116/5 "2022-03-23T03:28:30Z")

</div>

Up to you. I can see arguments both ways.