Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function
What is the formular to find the highest number value in a row of numbers.
This formula would have ot ignor some numbers that have an (*) beside them. If you could please help me out, thanks. Anthony |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function
Since number with an asterisk are text you can use
=MAX(A1:M1) adapt top fit -- Regards, Peo Sjoblom "Anthony" wrote in message ... What is the formular to find the highest number value in a row of numbers. This formula would have ot ignor some numbers that have an (*) beside them. If you could please help me out, thanks. Anthony |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function
row or column? beside - in another column?
=MAX(IF(B2:B200<"*",A2:A200)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Anthony" wrote in message ... What is the formular to find the highest number value in a row of numbers. This formula would have ot ignor some numbers that have an (*) beside them. If you could please help me out, thanks. Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |