Data analysis

[shamshersadiq]

I want to select only one peak at every zero crossing as shown in .jpg file and also attached excel sheet.

Thanks.problem.JPG

[wanmuhd]

Hi

Probably you can hide the data instead of delete it.

[shamshersadiq]

Its not posible to hide.
Please see the problem, i would be having 20,000 points,i want only one peak value at zero crossing,as you can see in attachment

[shamshersadiq]

Its not posible to hide.
Please see the problem, i would be having 20,000 points,i want only one peak value at zero crossing,as you can see in attachment

[wanmuhd]

Hi

I think there is no excel attachment. I saw only the jpg

[shamshersadiq]

https://www.dropbox.com/s/dzwz3pfv41...sing.xlsx?dl=0
Please download sheet from following link

[wanmuhd]

Hi

Would you like to try as per attached.
Please use the formula in column O to S.
Then, when you want to tabulate the data, you can use the O & S.
Oho, before that, you may need to put filter from O to S.
Then, in column S, you may untick the blank. Therefore, you will only get the data that you want for your chart.
Hope this will help you.

[shamshersadiq]

Great it work.
Thanks a lot for you help.