Increase number in formula when using fill

[SunValley]

I have the following formula in column A1

=IFERROR(LARGE(UNIQUE(B$2:B$100),3),"")

So when filling cell A2 with this formula, I would like the number to progress, for example:

=IFERROR(LARGE(UNIQUE(B$2:B$100),4),"")

It's possible?

 

[Joe4]

Change the formula from:

=IFERROR(LARGE(UNIQUE(B$2:B$100),3),"")

to

=IFERROR(LARGE(UNIQUE(B$2:B$100),ROW()+2),"")

 

[SunValley]

Change the formula from:

=IFERROR(LARGE(UNIQUE(B$2:B$100),3),"")

to

=IFERROR(LARGE(UNIQUE(B$2:B$100),ROW()+2),"")

Thank you very much

 

[Joe4]

You are welcome.
Glad I was able to help!