On 22/03/13 17:10, T. R. Valentine wrote:
I prefer in another cell the formula: =BG=G5 It only works for two
cells, but it is quick.
Thanks Guys for the help - all working now!!
My problem was that as I am working with CSV data I had set the whole
spreadsheet to be 'Text'. Therefore the result of the EXACT equation did
not show up as it was being accepted as plain text!! I converted that
column to Boolean and Viola!!
The other great thing I learned was Valentine's "shortcut" above!!! What
a wonderful way to do this. I'm doing a lot of work with CSV data at the
moment and this check between columns saves me a lot of time so I use it
a lot.
Thanks a lot for this Valentine!! *This "shortcut" deserves to be
included in the Help Files*.
As always thanks a lot for the awesome support!!
IanW
Pretoria RSA
--
For unsubscribe instructions e-mail to: [email protected]
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
