Ask Your Question
0

Two columns values

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

brs gravatar image

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

Hi,

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?

Thanks!!

libreOffice Calc Version: 4.2.8.2 English

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

karolus gravatar image

Use the next Column to compare the Values eg.

=Q1<=P1

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

edit flag offensive delete link more
0

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

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.
Menu/Tools/Filter/Advanced.
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

Stats

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

Seen: 840 times

Last updated: Sep 25 '15