Forum Discussion
danfrey718
Dec 29, 2023Copper Contributor
Getting Rid of Unwanted Data
I have a list of data that is about 2400 seconds long, and includes data up to the hundredths decimal place. Is there a function or filter I can use in order to just keep the integer values and delete all entries with decimals?
You may add helper column with =INT(cell)=cell, filter data on this column on FALSE, select all what is filtered and delete