Eric Zwiekhorst

asked on

# Divide top cell with lowest cell between top cel and cel I am in

I want to divide the topcel of a column with the lowest value I find between this top cell and the cell above the cell with this formula.

Could you give me the formula?

Kind regards

Eric

Could you give me the formula?

Kind regards

Eric

ASKER

Dear Bullwinkle,

I forgot to mention that not all the cells in this region are filled.

The lowest value must be a number higher then 0

Thanks for the quick respond

I forgot to mention that not all the cells in this region are filled.

The lowest value must be a number higher then 0

Thanks for the quick respond

This probably isn't the most efficient but will work.

=A2/MIN(IF($A$2:$A10>0,$A$3:$A10,1000))

Array Formula, so used Shift+Enter after copying the formula, and it should appear inside curly braces.

=A2/MIN(IF($A$2:$A10>0,$A$

Array Formula, so used Shift+Enter after copying the formula, and it should appear inside curly braces.

ASKER CERTIFIED SOLUTION

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

ASKER

Super and very quickly

I'm a little confused by your question. Given the following values in Col A, what do you want to do?

Heading

3.4

5

10

1.5

7

6

4

Heading

3.4

5

10

1.5

7

6

4

Mr bullwinkle's first formula works fine even if there are blanks

$A$2/Min($A$3:$A10)

$A$2/Min($A$3:$A10)

I'm assuming your formula is is D10

To reference Column A, the the formula would be

$A$2/Min($A$3:$A10)