On 22 March 2013 06:18, Ian Whitfield <whitfi...@telkomsa.net> wrote:
> What is the correct syntax for 'EXACT' to compare text names in two
> columns??
>
> The help files give - EXACT("Text1","Text2")
>
> But I want to use the Cell references.
>
> I tried EXACT(B5,G5) but this does not work - I tried with and without
> inverted comas and with a ';' in place of the',' but no luck!!
I prefer in another cell the formula: =BG=G5
It only works for two cells, but it is quick.
--
T. R. Valentine
Your friends will argue with you. Your enemies don't care.
'When I get a little money I buy books; and if any is left I buy food and
clothes.' -- Erasmus
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
