Hello,
I need help with cleanup of my data. I am using an excel 2016 version, so filter formula does not work.
I need a formula to which removes data that is below 1% of highest data (intensity) and gives the rest of the data in the new sheet. I tried to do this with IF formula but it creates blank rows/"false" that I do not want. I can filter out the blank cells using filter function but I have data from 15 different measurements in the same sheet. And want to keep it this way. If I use filter function in one data the other 14 changes. Any suggestion to properly cleanup my data? Really appreciate your help.
I have attached my excel sheet. The first sheet contains the raw data. In ''Sheet 1'' I tried to use the IF formula.
Warm regards,
Amin
Bookmarks