change values on listbox

[rafael5958]

Hi, what do I have is:

COL1	COL2
AAA	AAA
BBB	BBB
CCC	CCC
DDD	MMM
EEE	ZZZ
FFF	SSS
GGG
HHH

My listbox has the expression

COL1=COL2

It returns the values 0 and -1.

I want to show only the value -1 ( when the values are equal), and change the value -1 for the text "Equal Values".

Is it possible??

[shiveshsingh · Accepted solution]

Hi

Please use this expression in listbox.

=if(COL1=COL2,'Equal Values')