Rank() issue

[first_last]

I'd like to create a function that creates a sequence number for rows that changes by Schedule Status.

Instance Rank

=Rank([Instance Creation Date])

I get this:

I need the count to 'reset' for each Schedule Status.

When I change the function:

=Rank([Instance Creation Date];([Schedule Status]))

I get this:

What I want:

Failures: 1 through 10; Complete: 1; Pending: 1

What am I missing?

[former_member198519 · Accepted solution]

try this:

=Rank([Instance Creation Date];([Instance Creation Date];[Schedule Status]))