Checking for repeated content

N

Number_8

I have a cell which is concatenated from otehr cells. I want to put
control in to ensure that it does not contain repeat a peice of tex
i.e. www.house.html.html - how can i do it?

Thank
 
B

BrianB

This should show the principle, which checks if C1 = D1. If they are th
same it adds "" (empty string) instead of D1.

=CONCATENATE(A1,B1,C1,IF(C1=D1,"",D1)
 
N

Number_8

May have been my explanation, basically I have A1 concatenating with B1,
C1, D1 and E1.

B:E all contain URLs in pull downs but only one can ever be selected. I
need to make sure that if more than one is seletced an error message
shows.

Thanks
 
D

Dave Peterson

I'm not quite sure I understand the layout, but this may give you an idea:

=IF(COUNTA(B1:E1)<>1,"Error",B1&C1&D1&E1)

(I'm kinda confused at what A1 concatenating with B1, c1, d1, e1 means.)
 
Top