Multi-Row formulas for dynamic range

[victorb]

Hi all,

I have a dataset with occasionally repeating identifiers, and want to be able to flag these when they happen. However, they don't repeat at the same intervals. I tried using a multi-row tool, but I can't just select Row-1, Row-2, etc.

As far as I know there isn't a Row-X type formula.

E.g.

Record ID	Identifier	Repeat?
1	123	0
2	234	0
3	374	0
4	123	1
5	232	0
6	234	1

Any idea on how to build in a loop into the formula that would test for all previous rows? Or is there any other formula that is better suited?

Thanks!

[LordNeilLord · Accepted solution]

Hey @victorb

Multi-row is definitely the correct tool for the job...you just need to make sure that you are grouping on identifier:

[victorb]

Fantastic! Worked perfectly. Thank you.