+ Reply to Thread
Results 1 to 2 of 2

Outputting values in column B that correspond to certain values in column A

  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Outputting values in column B that correspond to certain values in column A

    Hi there,

    I need some help with a spreadsheet and I wonder if one of you could assist?

    I have two sets of data, one is a set of measurements and one is a calibration standard (i.e. what the data should be if it was collected perfectly). I want to divide the measurements by the standard to get a response curve. However, the standard has a lot more points in it than the measurement and the points in the standard are not evenly spaced. Here's an example of some of the data:


    0.61 400.09
    0.61 400.3
    0.61 400.52
    0.61 400.73
    0.62 400.95
    0.62 401.16
    0.62 401.38
    0.62 401.59
    0.63 401.81
    0.63 402.02
    0.63 402.24
    0.63 402.45
    0.64 402.67
    0.64 402.88

    Here I'd like to output something like

    0.61 400
    0.62 401
    0.63 403
    0.64 404

    Is there any way to do this? (It isn't linear the whole way)

    Thanks.

  2. #2
    Registered User
    Join Date
    06-22-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Outputting values in column B that correspond to certain values in column A

    bumpbumpbump

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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