I have a column of numbers both positive and negative. I want to get a table of the 4 largest absolute values WITHOUT having to create another column of those numbers as absolute values.
I tried LARGE(abs(A1:A34),1) - then 2,3,4 - but it came back #NUM. Any thoughts?