Feb 21 2023 06:02 AM
I have some data from a noise meter as CSV values down a column.
Some of the entries show
"UNDER RANGE" instead of a value.
How can I easily remove those entries prior to processing the data?
Feb 21 2023 06:07 AM
Perhaps the simplest is to apply filter to that column, unselect "UNDER RANGE", copy filtered range and paste it into new location, better in new sheet.
Feb 21 2023 06:09 AM
=IF(ISNUMBER(A1),A1,"")
You can try this formula. Then you can copy the data in range B1:B18 and paste only values. If you work with Excel 2019 or later you can apply the FILTER function.
Feb 21 2023 04:07 PM
Thanks. Using Microsoft 365 so I'll give Filter a go.