There are some random values in column “A15:A68” ranging from 960 to 2020.
There is a cell “C1” containing value 1648.
I need list of ONLY values greater than the value in C1 (without any blank or zero values, as it happens if I use “IF” function) in column B. in libreoffice calc
How to do this ?
thank you
You only need two simple formulas and the Data menu
The first formula to denote the title of your data is =A14. Second formula to set the desired condition is =">"&C1.
Do the rest with the mouse.
Thank you JohnSUN.
I tried this advanced filter thing, but did not know that “greater than symbol” should be placed within inverted commas and followed by ampersand… Yes, it works now.
=">"&C1
thanks once again.