Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Symbols with IF Function.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Symbols with IF Function.
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Symbols with IF Function.
You could use this in B1, copied down:
=IF(A1=MAX(A:A),"<==","") The: "<==" makes for a pretty close approx to an "arrow" pointing to the maximum(s) in col A, I reckon (the artistic side is crying out here) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Symbols with IF Function.
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" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Symbols with IF Function.
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 (%). "John" wrote: 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" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Symbols with IF Function.
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 --- "GEM" wrote: 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 (%). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function that returns symbols as formula result eg up/down arrow? | Excel Worksheet Functions | |||
inserting symbols not available in excel | Excel Discussion (Misc queries) | |||
Inserting Pictures with IF function | Excel Worksheet Functions | |||
Inserting Symbols | Excel Discussion (Misc queries) | |||
Inserting greek symbols in the legend ? | Charts and Charting in Excel |