Using the FILTER function to filter out data
I have a large spreadsheet with over 3000 entries and multiple columns of data. I need to efficiently edit out a specific packet of data that repeats in this case its the phrase “inactive” for one specific column. What formula can I use that will parse this column and remove all entries that have “inactive” in this column? Thank you, if this was not clear enough I can provide more information.
I have a large spreadsheet with over 3000 entries and multiple columns of data. I need to efficiently edit out a specific packet of data that repeats in this case its the phrase “inactive” for one specific column. What formula can I use that will parse this column and remove all entries that have “inactive” in this column? Thank you, if this was not clear enough I can provide more information. Read More
