Inserting Symbols with IF Function.

[GEM]

On column A, I have numbers running down to row 100. I want to add an IF
function on column B which inserts an arrow (â†) next to the highest number
from column A. It dosen't matter if the highest number on column A is
repeated as long as the arrow (â†) is inserted everytime the highest number
appears.

Another question is if this can be done if I used the "&" on column A. For
example, A1=D1+C1&" - "&E1+F1. I want to know which is the highest number
from column A, but from the second string, that is E1+F1.

 

[Max]

For the core issue in your 1st question
Your source nums running in A1 down
In B1, copied down: =IF(A1=MAX(A:A),"x","")
will flag the cell(s) in col A which are max as: x
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[John]

Hi Gem
If you select Wingdings 3 font for column B, you can use this
=IF(A1=MAX(A:A),CHAR(33),"") and you will get your arrow .
BTW, Wingdings3 is all types of arrows, check it out.
HTH
John

 

[GEM]

Thank you!! What I did is instead of x or CHAR(33) y insterted the arrow (â†).
That worked, but only if there is a single number on column A, what if there
is two results in one cell, I used the &. How can I identify the second
number in the cell.

For example,
A1=$23.00 - 15.00%
A2=$3.00 - 20.00%
A3=$13.00 - 10.00%

I want the arrow in column B to appear on B2, because that's the highest
percentage (%).

 

[Max]

In B1:
=IF(ISNUMBER(SEARCH("-",A1)),MID(A1,SEARCH("-",A1)+1,99)+0,"")

In C1:
=IF(B1=MAX(B:B),"<==","")
Copy B1:C1 down. Hide col B. And that should achieve it for you. Adjust the
formula in C1 for the desired "arrow".

P/s: It's always much easier to calc/work directly on numbers. TEXT displays
(from concat strings) should be saved for use only as the "last" end-results,
where you're sure that there will be no further downstream calcs required.

voila? celebrate it, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik