Question

How to separate less than value from entire column in excel?

Answer 1

Using formulae (=if(column<=value,true,false)) you can separate the values in excel.

Also you can apply filter on the desired column.