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
---
"GEM" wrote:
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.