Filter column data by time interval and count the number of records for each interval
I have a column of "timestamp" data (in mins) which i want to filter by a given time interval, say 10 mins. Then i want to count the number of records for each time interval and output the data to a sheet. how can i achieve this? through vba? can anyone kindly provide some code?
I attached a pic illustrating what i want to accomplish.
Re: Filter column data by time interval and count the number of records for each interval
Please upload a sample template of your workbook with enough data in it using "Go Advanced" option. The chances of you getting a response are more when you upload a workbook rather than an image.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By RM1984 in forum Excel Formulas & Functions
Last Post: 02-27-2014, 11:30 AM
By czou6 in forum Excel Formulas & Functions
Last Post: 03-10-2013, 04:45 PM
By sannyy in forum Excel General
Last Post: 04-23-2012, 10:06 AM
By chinkygirl in forum Excel General
Last Post: 02-11-2012, 01:33 PM
By email@example.com in forum Excel Charting & Pivots
Last Post: 04-15-2005, 01:06 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1