Is it possible to replace this countifs formula with something Glide computed? (Without using YC)

```
=ARRAYFORMULA(if(isblank(A2:A),"",if(if(A2:A=A2:A,COUNTIFS(A2:A,A2:A,ROW(A2:A),"<="&ROW(A2:A)),)=1,"1","2")))
```

Is it possible to replace this countifs formula with something Glide computed? (Without using YC)

```
=ARRAYFORMULA(if(isblank(A2:A),"",if(if(A2:A=A2:A,COUNTIFS(A2:A,A2:A,ROW(A2:A),"<="&ROW(A2:A)),)=1,"1","2")))
```

Yes, of course.

Just create a self-referencing multi-relation on the names column, and then a roll up on that to get a count.

That gives me the total count or a unique count. What I’m looking for is the first time the Name appears count = 1 and the second time the Name appears count = 2

ah, right. Let me think about that for a bit

What is the end result you are looking for? if you describe that, it will be easier for us to give you a solution. G sheet logic doesn’t always translate well to glide functions, but there is a elegant way to do it, if we know what u are trying to achieve.

First I make a duplicate set of names using a Query in GS. Then using the countifs formula I’m able to flag the first and second occurrence. Finally in glide using if-then-else I can control the left and right side column values in an inline list X2 per row.

i.e. If count=1 Last Week if Count=2 This Week

Sort of like a Button Bar but I need a Card Style Layout. I have the desired functionality, I’m just a big fan of getting rid of formulas and this one is referenced a lot.