Forum Discussion
parsing data in excel
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. ...
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.
It is best to post a small example of your data, and identify the expected results.