Thread: Maximum Absolute values
View Single Post
  #3  
Old September 23rd, 2008, 06:58 PM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
  
Posts: 8,419
Default Maximum Absolute values
Hi,

=MAX(ABS(A11))

Which must be array entered by pressing CTRL+Shift+Enter

Mike

"HW" wrote:

I have a set of values in 4 columns that I need to see as positive or
negative. However, I need a 5th column to show me the maximum of the
absolute values of those 4 columns.