Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 21 Sep 2015 16:37:30 +0200Two columns valueshttps://ask.libreoffice.org/en/question/58061/two-columns-values/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 brsMon, 21 Sep 2015 16:37:30 +0200https://ask.libreoffice.org/en/question/58061/