Sorry if this has been asked and answred somewhere else, but I can't find it.
I have a table which has multiple entries for a client, i want to show those entries on one line having given each a code via a formula, i.e LDD = Yes if it exists, like this
Client Code 1 Code 2 Code 3
1 Yes Yes Yes
2 Yes
Trouble is, what i get is
Client Code 1 Code 2 Code 3
1 Yes
1 Yes
1 Yes
2 Yes
Anybody have an idea how I can show these on one line to save me then having to put it into excel and manually take out the diffrences.
IP Logged
