Array formula for FFT

New Contributor


I would like to know what is the equivalent array formula for the FFT analysis which is available in the

pull-down menu and which gives the result in a form real +i*imag in a sinlge output column.
I have tried ={FFT(...)} spread on two columns but it is not at all the same thing.
Any help will be greatly appreciated.

1 Reply
After checking my results, I found the origin of the discrepency:
When you use the FFT function from the Data Analysis pull down menu, the output result is a single column with real and imaginary part NOT divided by the number of points of the FFT. If you use the array formula, the real and imaginary parts are available in two adjacent columns and both terms ARE already divided by the size.
Hoping this will hopeully help some excel users.