Forum Discussion
Need help to build Excell macro
Convert data to a table, select data then from Insert tab select Table.
Place cursor in table and go to Data tab, then select get data from table.
When the query editor opens filter you column by 60 sec intervals, then click close and load.
And it will return data into a new tab with what you want.
Thnaks for your reply.
Will I have to be able to repeat that steps for all my sample each time ?
the final approach is that :
- I have an acquisition system which run for 30mn and collect a big bunch of data
- For this acquisition set I need to extract every 30s sample measure
Then I need to run the same process for an other set of 30mn acquisition and need to extract the same thing.
At the end I can compare each extracted values for each acquisition set.
I was thinking of using MACRO because the same operation will be done many time.
Does your approach with Power Querry run in similar , meaning that as soon it is created once I can apply it for other set of data without recreating it ?
regards
- Its possible by using parameters, and passing the table name to the query.
Using Excel to do this seem like the wrong tool. I personally would fire this into a database and then you could manipulate in a multitude of ways to achieve the above requirements repeatedly and consistently without manual intervention ...Hello stephen
I have try what you sugest, I convert my data to table.
my data first column contains hh:mn:ss
how can I apply filter which takes every 30s sample interval ?
at the end I should keep data from 30s, 1mn, 1mn30s, 2mn,.... until the end of recorded data
Thnaks for help
