Date Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2270713%22%20slang%3D%22en-US%22%3EDate%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2270713%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20working%20in%20Office%20365.%26nbsp%3B%20I%20have%20an%20Excel%20file%20that%20collects%20data%20every%203%20seconds%20so%2020%20entries%20per%20minute.%26nbsp%3B%20I%20only%20need%20data%20once%20per%20minute.%26nbsp%3B%20How%20can%20I%20filter%20out%20the%20other%2019%20entries%20per%20minute%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2270713%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I'm working in Office 365.  I have an Excel file that collects data every 3 seconds so 20 entries per minute.  I only need data once per minute.  How can I filter out the other 19 entries per minute?

4 Replies
I'm having trouble getting a graph on my powerpoint there is no chart option

@LarryEl2210 

Perhaps data in the sample file is already partly cleaned. For the raw data you may add helper column as

image.png

With that you need only rows where the second is equal to zero. How to remove it depends on how dynamic your data and which functionality of Excel do you use. In simplest manual way filter all but zero

image.png

select all rows till end of the range, Delete rows

image.png

clear filter

image.png

Home

image.png

In general you may use Advanced Filter or Power Query to copy filtered data into another location or VBA to remove extra rows in place.

thank you very much!  This did exactly what I needed! @Sergei Baklan 

@LarryEl2210 , you are welcome, glad to help