From a number of cells to pick the highest value

[andreas1976]

1. I have 5 cells from B6 to F6 and i want to create a formula in cell H6 to return as a result the highest number from cells B6:F6

2.I have 5 cells from B3 to F3 and i want to create a formula in cell H3 to return a result that has the following rules:
in case of positive result in any of the cells B3:F3 to write in cell H3 "Possitive".
In case of any other result except positive to write in cell H3 "Negative". I have 5 cells from B6 to F6 and i want to create a formula in cell H6 to return as a result the highest number from cells B6:F6

Any idea please for the above 2 problems.

[Pete_UK]

In H3:

=IF(COUNTIF(B3:F3,"Possitive"),"Possitive","Negative")

I have used your spelling for "Positive", and you may need to change the commas ( , ) to semicolons ( ; ), depending on your regional settings.

In H6 you can use this array* formula:

=MAX(SUBSTITUTE(B6:F6,"<","")*1)

Note that an array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE), instead of the usual Enter.

Hope this helps.

Pete

[andreas1976]

Thanks Pete_UK!

It works perfectly!!!

[Pete_UK]

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete