Rank if with a priority

[Hawsie]

I am trying to create a formula to do a rank if that also responds to a priority designation.

In my attached example column D should rank the oldest records by productID and all items with priority 2 should come after all items with priority 1.

 

[Hui]

see how this goes:


see attached file:

 

[NARAYANK991]

Hi ,

See if this is OK.

If you want to add one more level of ranking according to the Product ID , that can easily be added. At present , your data does not show that this is necessary.

Narayan

 

[Hawsie]

Thank you both for your responses, I can see that you are going to be able to solve this puzzle.

I realized that I didn't explain one part of my issue very well. I do want to group the results by product ID so that the rankings should only compare items with the same ProductID. The example I posted actually shows what the required output should be. (The Rank column is the needed output)

So the output would have these requirements:

1. A separate ranked set for each unique ProductID
2. Within a ProductID all priority one rows would come before any priority two rows
3. Within a ProducutID priority one rows would be ranked oldest to newest and then priority two rows would continue the ranking set, also oldest to newest

Thank you so much for spending time on this.

 

[Hawsie]

I was able to take NARAYANK991's approach and tweak it a little. See the sample.