Multi Row Formula Delete Duplicate

[babe]

Hello,

I am trying to see if a row look like the next Row. I am using Multi Row formula but it doesn't work. 

Case	FL	AU	Entity	Value
A21300	F20	1LIA00		-0.01653650
A21300	F20	1LIA00	999999	-0.01653650
A26000L	F92	8TIT05	dFF	-0.02000000
P10610	F92	8TIT05		-0.05000000
R65800	F10	1LIA02		-0.20833300
R65800	F10	1LIA02	999999	-0.20833300

I would like to see if the values in all the column except the column "Entity" is the same as the next row. I would like to put an "1" when the next value of next row are similar to the row we analyze ( except for the column "Entity"). An "1" will be put in place if the row is similar for the column : Case, FL , AU and Value    and not for the column Entity

The result  will look like this :

Case	FL	AU	Entite	Value	Resultat
A21300	F20	1LIA00		-0.01653650	0
A21300	F20	1LIA00	999999	-0.01653650	1
A26000L	F92	8TIT05	dFF	-0.02000000	0
P10610	F92	8TIT05		-0.05000000	0
R65800	F10	1LIA02		-0.20833300	0
R65800	F10	1LIA02	999999	-0.20833300	1

Thanks you in advance for your helps,

Best regards!

[ShankerV · Accepted solution]

Hi @babe 

Please find the expected output.

[Luke_C · Accepted solution]

Hi @babe 

Here's an example:

[ShankerV]

Hi @babe 

Please use the filter post Multi row formula, to remove (delete) the duplicate.

Many thanks

Shanker V

[binuacs]

@babe One way of doing this

[ShankerV]

Hi @babe 

Another way to use Unique tool.