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()))
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()))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks