Re: [libreoffice-users] LO Calc - How to compare Text in two columns?

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: users+help@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