+ Reply to Thread
Results 1 to 2 of 2

extracting the peaks of data and plot "zoom-in" of the peaks

  1. #1
    Registered User
    Join Date
    10-28-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    30

    extracting the peaks of data and plot "zoom-in" of the peaks

    HI,

    how can I get the cell indexes of all cells which has data above 5?
    xsl with data attached

    then I need to plot the sequence of 10 numbers around it (to get a graph of the each peak)

    thanks in advance
    Attached Files Attached Files
    Last edited by michael.g; 11-02-2009 at 05:30 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: extracting the peaks of data and plot "zoom-in" of the peaks

    Try look here:

    example.xls

    However, I have one more question:

    In row 12 is peak 3,375.

    Why it's not considered as a peak?

    Therefore I add in F1 cell where you say what's your minimum value for a peak.

    But if you have some other idea it can be adopted.

+ 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