Results 1 to 10 of 10

peak picking help

Threaded View

Guest peak picking help 03-06-2009, 01:10 PM
shg Re: peak picking help 03-06-2009, 02:02 PM
Guest Re: peak picking help 03-09-2009, 09:25 AM
Andy Pope Re: peak picking help 03-09-2009, 10:05 AM
Guest Re: peak picking help 03-10-2009, 10:24 AM
Andy Pope Re: peak picking help 03-10-2009, 10:38 AM
theoneness Re: peak picking help 11-21-2009, 06:28 PM
teylyn Re: peak picking help 11-21-2009, 06:31 PM
herbds7 Re: peak picking help 04-08-2011, 09:32 PM
teylyn Re: peak picking help 04-08-2011, 10:42 PM
  1. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: peak picking help

    You could use a formula in column C with which to filter the peak values
    Filter on Not Equal #N/A

    C2: =IF(AND(B2>B3,B2>B1),B2,IF(AND(B2<B3,B2<B1),B2,NA()))
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

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