parsing data in excel

New Contributor

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

3 Replies
Your description "parse that data to extract what frequencies are above defined value" is ambiguous. If your extraction criterion is only the frequency, no parsing is necessary; you could just FILTER the data (either manually or by formula). If the extraction criterion is embedded in the spectral data, you will need to be more specific. Also, remember that to use VLOOKUP, the data must be sorted by the lookup value (frequency?).

It is best to post a small example of your data, and identify the expected results.



The FILTER function would do this. you will need a relatively new version of Excel to employ it. Here's a good intro.


Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, but were limited to power users. With Dynamic Arrays we have rebuilt the calc engine, effectively turning all formulas into array formulas ...
RESOLVED: Conditional filters work