Forum Discussion

danfrey718's avatar
danfrey718
Copper Contributor
Dec 29, 2023

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?

  • danfrey718 

    You may add helper column with =INT(cell)=cell, filter data on this column on FALSE, select all what is filtered and delete

Resources