seeing duplicates across two fields

[#1]

I have three fields supporter number, last name and postcode. What I am trying to do is to put a condition on the background colour of supporter number to say if the postcode and last name combination appears twice i want the supporter number to be coloured.

I understand where to put this condition but I cannot work out what condition to use

thanks in advance

Rosie

[Miguel_Angel_Baeyens]

Hello Rosie,

You may use in the color expression something like

=If(Count(PostCode & LastName) = 2, RGB(200, 200, 200))

where the "&" operator concatenates PostCode value to LastName value.

Hope that helps

[#3]

Thanks Miguel

But unfortunately that is not working!

Any more help would be greatly appreciated

[Miguel_Angel_Baeyens]

Hello Rosie,

What fields do you want to look for? Are they already in the table?

[#5]

I have a straight table of Supporter Number as the dimension and [Postcode] and [Last Name] as expressions, I want to know if there are any repetaed postcode and last name combinations and if there is colour the supporter number a different colour

Thanks

Rosie

[#6]

Hi,

Sort the table with [Postcode] and [Lastname] in ascending order and try the following expression:

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

=if([Postcode]=peek([Postcode],-1),if([Lastname]=peek([Lastname],-1),rgb(100,100,100)))

hope this one works.

Cheers,

Haneesh

[#7]

Sorry Haneesh this is not working either

any other suggestions?

Thanks

Rosie

[#8]

Hi Rosie,

Can you attach your document with some sample data. I will try to update the expression to get the desired result.

-Haneesh

[#9]

this is my document using just a sample

[#10]

data