Search:

Type: Posts; User: sambisu; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Transposing data entries grouped vertically

    Thanks so much! Worked perfectly.
  2. Transposing data entries grouped vertically

    I have a large data set that is arranged something like shown below with a space between each data entry. I'd like to rearrange the data in a normal table, with the field labels across the top and...
  3. Replies
    3
    Views
    136

    Re: Min Max Average

    Seems like I just need another term in there to test for the hour. So maybe like a subgrouping under each day? I've been messing around with it, but I can't quite figure out how to do that.
  4. Replies
    3
    Views
    136

    Re: Min Max Average

    Yes, 24 hours. My previous data was every 30 minutes and I was wanting to reduce to daily data. Now I have a different data set that has data points every 40 seconds or so and I want to reduce it to...
  5. Replies
    3
    Views
    136

    Min Max Average

    I have the following macro for taking a data series and extracting daily min/max/average. I would like to convert this to extract hourly min/max/average instead of daily, but not sure how.

    Sub...
  6. Replies
    0
    Views
    141

    Help with complex oscillating data

    I have some fairly complex oscillating data that I would like to try to extract frequency data from. The magnitude of the oscillations is not consistent and is trending down over time.

    Any help...
  7. Re: Macro to extract min/max/average data from large data set

    Worked great! Thanks so much!
  8. Macro to extract min/max/average data from large data set

    I have a large data set (~70,000 rows) that contains temperatures at various dates/times. Column A contains the date/time and B contains temperatures (see below). What I would like to do is create a...
Results 1 to 8 of 8