Ask Your Question

Two columns values

asked 2015-09-21 16:57:57 +0200

brs gravatar image

updated 2015-09-22 12:29:31 +0200


I have two columns with numbers, lets say column "P" and "Q". (loads of rows) Now I want to filter the data, so that "Q" column will have ONLY values smaller or equal to those in column "P". So if in row 2; "Q" is of value 3 and column "P" of the same row will have a value of 2, it will filter it out.

Final data would be those rows of column P and Q where this "correlation" or values of Q smaller or equals to P in the same row.

If i go Standard filter I cant change Value to Column, if you know what I mean. Do i need to use any function?


libreOffice Calc Version: English

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-09-25 07:53:13 +0200

karolus gravatar image

Use the next Column to compare the Values eg.


pull down the Formula and filter on Kriteria True for Helper-Column

edit flag offensive delete link more

answered 2015-09-24 23:35:13 +0200

m.a.riosv gravatar image

You can do it with advanced filter, because it take the filter from a range of cells, and in those cell you can set up the correlation.
In the help there is an example on how to use it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-09-21 16:37:30 +0200

Seen: 1,129 times

Last updated: Sep 25 '15