Quote:
Originally Posted by Adam
Hi thanks very much for your help -
one problem
I need to see duplicates of the date still if they have different codes.
Sorry, should have put that in my first question.
|
Adam:
I’m still a bit confused when you say, “I need to see duplicates of the date still if they have different codes”. I’m guessing you mean to say, “I need to see duplicates of the date regardless of the different codes”? I hope I’ve got that right. Populate column AA with this formula.
Code:
=IF(OR(A2="",G2=""),"",IF(COUNTIF($G:$G,G2)1,RANK($G2,$G:$G,0)+ROW()/100000,""))