Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Rosie,
look the attached example. Is what do you need?
Andrea
when the postcode and last name combination are repeated I need for the supporter number to go a different colour
Thanks
Rosie
Hi,
like this?
Andrea
Hi Rosie,
sorry lloking more deep I see that it's not working every time.
I keep looking.
Andrea
Hi Rosie,
now seams to work on your sample data. Take a look in the script where I have created a key field.
Andrea
Thank you very much that has worked!
Rosie
have just gone through all my data to check,as have over 10000 rows but unfortunately have now discovered has not worked
Thanks
Rosie
Can you post the data?
Andrea
no sorry I cannot
Rosie
Ok, just the 3 fields like before but with the 10.000 records?
I just tried out on one table and seams to work.
Andrea