ExcelBanter - FFT in a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - FFT in a macro (https://www.excelbanter.com/excel-programming/447065-fft-macro.html)

Mac M

FFT in a macro

Hi All,

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. Thank you for help.

joeu2004[_2_]

FFT in a macro

"Mac M" wrote:
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...-t1006197.html, especially
Dana DeLouis's response at the end.

All times are GMT +1. The time now is 10:10 AM.