Lookup (or IF) the next unique number based on a value of Y or N in another cell

if you want the number to increase by 1 each time, and you dont actually have those numbers anywhere, you can use the =max(range-above)+1 to reference the range above and add 1