Mark first distinct row in data set

I am trying to mark the first distinct occurence in some excel data. Basically, I have Products, which have an Insertion Date and a Price Deviation.

I managed to get the Max Date of each Product by using =MAX(IF(A2=$A$2:$A$13;$B$2:$B$13;"")), as an array formula. Furthermore, I also managed to get the latest deviation amount by using, =MAX(IF(E2 = $B$2:$B$13; $C$2:$C$13; "")).

My idea, was to check for the date and the deviation amount and find the products which have the latest insertion date and the highest deviation amounts on a distinct product level.

However, my insertion date and price deviation are not an unique identifier.

Here is an example:

Any suggestion, how to mark only the first occurence of an insertion date and deviation combination?

I appreciate your replies!

Answers


I'm sure this could be done more elegantly:

=IF(OR(B2<>E2,C2<>F2),"",IF(COUNTIFS($A$2:A2,A2,$B$2:B2,E2,$C$2:C2,F2)=1,F2,""))

Need Your Help

jQuery script working in Firefox and Coda (IDE) but not Chrome

javascript html jquery cross-browser

It's way too much code to put here so here's the link to where I'm temporarily hosting it. http://theowindebank.co.uk/jailbreak.

How to incorporate Quine–McCluskey Algorithm with Composite Specification Pattern

c# algorithm design-patterns boolean-logic boolean-expression

I want to incorporate the Quine–McCluskey Algorithm with Composite Specification Pattern.