It's all about the Software

G0OFE wrote: ↑Fri Aug 20, 2021 3:50 pm
Need a new column with a formula - e.g A2/1000000 - it's what I did.

I knew that! But it is a bit more subtle than that because I've a number of frequencies offset by 13 kHz to improve RDS detection next to strong locals. It will probably be easier to change these frequencies in favourites to use the offset filter setting.
I aalso need to check I haven't accidentally got one lot of frequencies imported as text and ended up with a data type mismatch - it won't be the first time!

Incidentally you shouldn't need a new column, you could use a formula within the vlookup function
eg =vlookup((A1*10^-6);'table'A1:B100);1,0). That's the formula I use in another table where one set of frequency data is in Hz and the other set of data is MHz.

Ah. Knew there might be a less clunky way of doing it!