FFT in a macro

[Mac M]

Hi All,

Would someone, please, show me the syntax for a macro that calculate
the FFT of many time series, arranged in columns? I am doing it one a
a time using the Analysis toolPak, and it is painful. Thank you fo
help

 

[joeu2004]

Would someone, please, show me the syntax for a macro
that calculates the FFT of many time series, arranged
in columns? I am doing it one at a time using the
Analysis toolPak, and it is painful.

Do a Google search for "excel atp fourier" without quotes. Look at the
several hits. In particular, see
http://www.pcreview.co.uk/forums/fft-usage-macro-t1006197.html, especially
Dana DeLouis's response at the end.