Mar 30, 2005 #1 got2bcrzy Technical User Mar 30, 2005 2 CA I need a formula that will calculate the range(the difference between the max and min)
Mar 30, 2005 #2 AnotherHiggins Technical User Nov 25, 2003 6,259 US something like: [COLOR=blue white]=max(A:A)-min(A:A)[/color] ? [tt]_____ -John [/tt]Help us help you. Please read FAQ181-2886 before posting. Upvote 0 Downvote
something like: [COLOR=blue white]=max(A:A)-min(A:A)[/color] ? [tt]_____ -John [/tt]Help us help you. Please read FAQ181-2886 before posting.
Mar 30, 2005 #3 Gavona Technical User Aug 27, 2002 1,771 GB =Max(range)-Min(range) Thanks, Gavin Upvote 0 Downvote