+ Reply to Thread
Results 1 to 3 of 3

Putting data series on same time frequency

  1. #1
    Registered User
    Join Date
    10-01-2008
    Location
    New York
    Posts
    13

    Thumbs up Putting data series on same time frequency

    Hi,

    I have 2 data series with different time resolution, but I'd like to put them on the same resolution. I'll give you a simplified example:

    Series 1:
    time1; force1
    0; 2
    1; 4
    2; 2
    3; 1
    4; 7

    Series 2:
    time2; force2
    0; 5
    2; 3
    4; 1
    6; 4

    So, I want to merge these 2 series, so they both refer to 1 time data set. It would look like:

    time; force1; force 2
    0; 2; 5
    1; 4;
    2; 2; 3
    3; 1;
    4; 7; 1
    and so on..

    How can I do that?

    Thanks!
    MLC

  2. #2
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150

    Smile

    Hi,
    Use Vlookup
    =Vlookup(0,Range,2, False)
    The range is series 2
    and drag down
    Hope this helps
    regards Howard
    Last edited by shg; 10-02-2008 at 03:38 PM. Reason: deleted spurious quote

  3. #3
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    A:B are the first series, C:D are the 2nd series
    F:G are the new series
    In column G
    Please Login or Register  to view this content.
    I need your support to add reputations if my solution works.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using a threshold to detect frequency of oscillations
    By abcd3fg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2008, 01:31 PM
  2. how to toggle the 'visible' property of a series
    By arioti in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-08-2007, 10:05 AM
  3. shifting online data comes to excel as per formula with very minimum timelag
    By cramatr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2007, 10:08 PM
  4. Insert/format Picture From Folder
    By Vlad999 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 01-18-2007, 10:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1