Counting duplicates based on condition(s)

[Rkustas]

Hello,

I am looking for a formula to count groups of duplicates based on a store #, and make sure it continues to count if the same store is listed further down the list.

Please see attached example; any help would be much appreciated.

Thanks!

rkustas

 

[NARAYANK991]

Hi ,

I am not sure about your requirement ; see if this is what you want.

Narayan

 

[Rkustas]

Sorry, I didn't explain very well, my desired output is column 2.

My condition would be every time the store number changes, add 1 to my order #.

Thanks.

 

[NARAYANK991]

Hi ,

See the revised file.

Narayan

 

[Rkustas]

Hi Narayan,

This is perfect. Thanks!