# Halp! Halp! If You Are Super Proficient With Ms Excel Please Come Here And Help Me!

## Recommended Posts

ok here is what i'm trying to do in ms excel.

say i have a table as follows

Coln A Coln B Coln C

1Time "Power kW" "Power Factor"

2 50 0.9

3 60 0.8

4 100 0.6

5 300 0.7

6 70 0.5

7 90 0.1

I then go in a different cell foruma "=MIN(C2:C7)" that would give the minimum power factor, which in this case would be 0.1

I want to know what the power kW (Coln and time (Coln A) is at this point in time where the minimum occurred. (I can't just go =MIN(B2:B7) that would just give 50 which isn't where the min pf occurred... get what i mean?)

What forumla/method do I need to do this, as in get the cell next to the cell of min?

Thanks in advance excel wiz master.

##### Share on other sites

Bookworm

The best I can come up with is to use VLOOKUP, but you will have to reorder your table so that power factor is the first colum and then sort the table so that the power factor is in assending order. Like so

PF TIME kW

0.1 6 90

0.5 5 70

0.6 3 100

0.7 4 300

0.8 2 60

0.9 1 50

then use

VLOOKUP(MIN(A2:A7),A2:C7,3) this will return the value in colum 3 from the row of the array that has the value that is the minimum of the range A2:A7

The problem with this is that you have to sort the data, which I guess to want to avoid doing.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account

• ### Who's Online (See full list)

• There are no registered users currently online
• ### Tell a friend

Love LMPForum? Tell a friend!
×