#### Golfpro1286

##### New Member

- Joined
- Aug 22, 2018

- Messages
- 30

I am not sure if it because it is Monday, but I am having trouble with a formula that I thought would be pretty easy.

Here is a simplified version of what I am trying to accomplish:

I have two columns (A1:B5) and a special cell A10 (ifgreater than 0). Column A is filled in manually with % values (i.e. 3.00%,2.50%, etc.) and I want the value from A10 to automatically show (just once)into the row of Column B that associates with the lowest % value in Column A.My initial formula (B1 example below) was easy enough:

<min(a2:a5)),$a$10,0)< span=""><min(a2:a5)),$a$10,0)

<min(a2:a5)),$a$10,0)

<min(a2:a5)),$a$10,0)

This works fine unless there are two or more % values that arethe lowest in the Column A set. If there are multiples of the lowest values, itsets them all to 0. If I adjust the formula to <= it sets them all to the A10value.

Any help would be appreciated.

Thanks!

</min(a2:a5)),$a$10,0)

</min(a2:a5)),$a$10,0)

</min(a2:a5)),$a$10,0)

</min(a2:a5)),$a$10,0)<>

Here is a simplified version of what I am trying to accomplish:

I have two columns (A1:B5) and a special cell A10 (ifgreater than 0). Column A is filled in manually with % values (i.e. 3.00%,2.50%, etc.) and I want the value from A10 to automatically show (just once)into the row of Column B that associates with the lowest % value in Column A.My initial formula (B1 example below) was easy enough:

<min(a2:a5)),$a$10,0)< span=""><min(a2:a5)),$a$10,0)

<min(a2:a5)),$a$10,0)

<min(a2:a5)),$a$10,0)

This works fine unless there are two or more % values that arethe lowest in the Column A set. If there are multiples of the lowest values, itsets them all to 0. If I adjust the formula to <= it sets them all to the A10value.

Any help would be appreciated.

Thanks!

</min(a2:a5)),$a$10,0)

</min(a2:a5)),$a$10,0)

</min(a2:a5)),$a$10,0)

</min(a2:a5)),$a$10,0)<>

Last edited: