Oct 11 2022 08:51 AM - edited Oct 11 2022 09:09 AM
I have data from spectrum analyzer which consists of 2 columns.
col A is frequency and col B is spectral data.
I would like to parse that data to extract what frequencies are above defined value.
I thought vlookup would work but doesn't appear to do the trick.
Any suggestions as to what functions that can be used for this task?
Example: What function would be used to extract frequencies (Col A) that have a value > -40?
I want the function to return the freq(s) and the value(s) that are > -40.
A B
0.1 -42
0.5 -40
1.0 -35
1.5 0
2.0 -35
2.5 -40
Oct 11 2022 09:01 AM
Oct 11 2022 09:21 AM
The FILTER function would do this. you will need a relatively new version of Excel to employ it. Here's a good intro.
https://www.youtube.com/watch?v=9I9DtFOVPIg