Welcome Guest [Log In] [Register]
Assalamoalaikum, We hope you will enjoy your visit here.

Join our community!

If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Indicators for the maximal and minimal values
Topic Started: Apr 26 2007, 06:57 PM (123 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins


Problem:

Creating a formula that will indicate the maximum and minimum values in List1 by returning ""Max Value"" or ""Min Value"" in the cell next to them.

Solution:

Enter the following IF statement, using the MAX and MIN functions, in column B:
=IF(A2=MAX($A$2:$A$8),""Max Value"",IF(A2=MIN($A$2:$A$8),""Min Value"",""""))
Offline Profile Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Posted Image
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply