is there a way to generate incremental number to name that is listed more than once

MarkCep

I have a store number; each store has a monthly store visit date. I am looking to use the store number and add the number to show how many previous visits there were before.

I have a formula to add an incremental number, but it did not represent the number for the specific store's visit.

Is there a formula that can get me to the Store Visit ID?

Hope that makes sense.

Thanks

MarkCep

I figured out -

=COUNTIFS([Store Visit Date]:[Store Visit Date], <[Store Visit Date]@row, [Store Number]:[Store Number], =[Store Number]@row)

then in the Store Number ID column - using that value, and joined it to the Store Number