• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

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
0
Eric Zwiekhorst
Asked:
Eric Zwiekhorst
1 Solution
 
RyanProject Engineer, ElectricalCommented:
I'm assuming the TopCell is Row 2.
I'm assuming your formula is is D10

To reference Column A, the the formula would be
$A$2/Min($A$3:$A10)
0
 
Eric ZwiekhorstTSE service engineerAuthor Commented:
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
0
 
RyanProject Engineer, ElectricalCommented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
RyanProject Engineer, ElectricalCommented:
Actually, you don't need the false part of the if. So the following works, with Shift+Enter.
=A2/MIN(IF($A$2:$A10>0,$A$3:$A10))
0
 
Eric ZwiekhorstTSE service engineerAuthor Commented:
Super and very quickly
0
 
Martin LissRetired ProgrammerCommented:
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
0
 
EirmanCommented:
Mr bullwinkle's first formula works fine even if there are blanks
$A$2/Min($A$3:$A10)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now