I'm trying to get automatic incrementation working for a dynamic range of data. I've got this convoluted formula that works in some of the cells but not others, returning a #Value error that doesn't make sense to me since it only occurs after a certain point. If there is a less complicated way to solve this, I'm absolutely open to it as well.
Columns B & C contain dropdown options for scheduling purposes. What I'm looking for column D to do is to auto increment the number based on whether that exact combination of names/shift has previously occurred. Sample sheet is here: https://docs.google.com/spreadsheets/d/1LMZgTRmh6cH0a2o0UBNHXPfHhlpFOg-2yEzAO7Us78s/edit#gid=0