EXACT Function

[Thiyagu_2011]

this function only have for two text only , what about if i need to use this function for more text more than 2..


Anyone can help

 

[GlennUK]

How about:

=AND(EXACT(string1,string2),EXACT(string1,string3))

 

[Thiyagu_2011]

Many thanks...Now i able to get what i want....
Thanks again.....

 

[T. Valko]

this function only have for two text only , what about if i need to use this function for more text more than 2..


Anyone can help

You can use a range of cells and array enter like this:

A1 = X
A2 = x
A3 = X

Array entered**:

=AND(EXACT("X",A1:A3))

** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

 

[Thiyagu_2011]

Many thanks...It's work