apply seach criteria to whole cells

Posted by Tom on Super User See other posts from Super User or by Tom
Published on 2012-06-08T03:46:21Z Indexed on 2012/06/08 4:42 UTC
Read the original article Hit count: 443

Filed under:

libreoffice-calc

I am trying to use MATCH() and/or LOOKUP() in LibreOffice Calc. I have the "Search criteria = and <> must apply to whole cells" and the "Enable regular expressions in formulas" options selected. The item I am looking for is a multi word string.

How do I provide a search criteria as a cell reference (E3) in to LOOKUP(E3, B1:B20, C1:C20) and have it match the value in B1:B20 EXACTLY? Right now it is matching partial strings rather than matching the cell values exactly.

Related posts about libreoffice-calc

Changing the cell range of conditional formatting in LibreOffice Calc

as seen on Super User - Search for 'Super User'
Is there any way of changing the range of conditional formatting in LibreOffice Calc (version 3.6)? I have a set applied already to a range of cells, but there is no obvious way of changing which cells a given set of conditional formatting is applied to. I either have to copy and paste the formatting… >>> More
LibreOffice Calc SEARCH and FIND functions

as seen on Super User - Search for 'Super User'
I am trying to process some data in Calc. One of the steps involve finding if a certain string is part of one of the column. I tried using FIND and SEARCH functions. Both behave in the same way and I am not getting correct results. E.g. Say I have following strings in Column A NY SF LON CAN US and… >>> More
Flexible argument list in LibreOffice Calc Macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to write a function that geometrically links performance data which is usually provided as percentages, so the function will basically return (1+a)*(1+b)*(1+c)* … *(1+x)-1 This should be done using LibreOffice-calc and it should behave similarly to the regular sum function. As you may throw… >>> More
Change the icon color in LibreOffice Calc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
There appears to be no way of changing icon color in a calc chart. After creating an XY scatter plot, I can select "format data series" and can change the icon symbol and size, but not the color. There is an drop-down for line color, but when I do not have lines displayed this drop-down menu is grayed… >>> More
System crash when trying to drag cells in LibreOffice Calc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Some time after upgrady to Saucy I noticed several freezes and crashes when simply trying to drag content of selected cells to another place in LibreOffice Calc (version 4.1.2.3 from repository). The system stops responding - although for example Clementine still plays music from playlist - I am… >>> More

Developer IT

apply seach criteria to whole cells - Developer IT

apply seach criteria to whole cells

libreoffice-calc

Related posts about libreoffice-calc

Changing the cell range of conditional formatting in LibreOffice Calc

LibreOffice Calc SEARCH and FIND functions

Flexible argument list in LibreOffice Calc Macro

Change the icon color in LibreOffice Calc

System crash when trying to drag cells in LibreOffice Calc

Categories cloud