Data Sorting by Cell Number

[Boatbuilder]

Is there an easy method to have data sorted by cell number? I have raw data being dumped into Excel fwith A1 being a reading at 0.01 second A2 being a reading at 0.02 seconds and so one. I would like reduce the reading frequency to 1 second, 1 minute, 1 hour and so on. Is this possible using cell numbers/addresses?

Thanks

[Greg M]

Hi there,

Do you want to DELETE the rows containing the "surplus" readings or just to hide/filter them?

Regards,

Greg M

[Boatbuilder]

I would like to keep the data and generate new colums using a filter to select the data output frequency.

If that makes any sense?

[deadlyduck]

Is this what you're looking for:

In cell B1 (for 1 second data):

Please Login or Register  to view this content.

In cell C1 (for 1 minute data):

Please Login or Register  to view this content.

In cell D1 (for 1 hour data):

Please Login or Register  to view this content.

You can copy these formulae down as far as you need

[Greg M]

Hi all,

The only problem with a formula-based approach is the amount of data involved. One hour's worth of data corresponds to over one million (360,000 * 3 - second, minute, hour) formulae to calculate and store.

A VBA-based approach might be neater - e.g. using VBA to generate three additional worksheets (second, minute, hour) & to copy the appropriate data to those worksheets.

Let me know if this type of approach would suit you and I'll see what I can do.

Hope this helps - please let me know how you get on.

Best regards,

Greg M