Help me

[XTC OKE]

 

Help

 

I want excel to help me organise the first 3 of a category, using the time they finished.

 

Let say

 

Mampara came in at 2:05:03

Mud Dee came in at 2:10:30

Holy roller came in at 4:10:15

Jules came in at 3:05:59

 

all of them are in the same category, how can I tell excel to sort them when all the results are mixed.

 

XTC OKE2009-09-08 04:35:00

[flex]

Edit your formula as follows:

 

=if(isna(vlookup(range,lookup range,column),"",vlookup(range,lookup range,column))

[XTC OKE]

will you edit it for me please, that is super complicated

 

=VLOOKUP(D6,'Entry Details'!$A$2:$C$478,2,FALSE)

 

[andrewc]

=if(isna(VLOOKUP(D6,'Entry Details'!$A$2:$C$478,2,FALSE)),"",VLOOKUP(D6,'Entry Details'!$A$2:$C$478,2,FALSE))

 

or if you're using Excel 2007 (I assume you're not, but I had to test it on my PC):

 

 

 

=IF(ISNA(VLOOKUP(D6;'Entry Details'!$A$2:$C$478;2;FALSE));"";VLOOKUP(D6;'Entry Details'!$A$2:$C$478;2;FALSE))

 

 

 

Cheers,

 

 

 

Andrewandrewc2009-09-07 12:30:14

[XTC OKE]

Thanks Andrew (im using office 2010 Technical preview)

[XTC OKE]

Ive got one more formula that gives me alot of ###########

 

here it is, what do I do with him?

 

=G6-$B$2

 

[andrewc]

I can't see anything wrong with the formula. What is it doing that you don't want it to do?

 

 

 

It will subtract the value in B2 from G6, but if you copy this formula to another cell, it will always subtract the value in B2, while the other cell reference will move relative to the original cell's position (as if that makes any sense).

 

 

 

Post what you need it to do... (or what it's not doing).

 

 

 

Cheers,

 

 

 

Andrew

[XTC OKE]

Im using a macro to subtract the current time from an (vaste tyd)

 

So when I enter a number it calculates the time, but on the cells that I dont enter a number there is alot of ######

 

[XTC OKE]

andrew, you dont know of a function in excel that can give you the 3 fastest times in say a category? or can one use conditional formatting?

[XTC OKE]

and another one : when linking a cell and there aint no data in it it displays a 0 can one turn the 0 off?

[XTC OKE]

ok bump got the zero one figured out

 

[Mats]

andrew' date=' you dont know of a function in excel that can give you the 3 fastest times in say a category? or can one use conditional formatting? [/quote']

I think you are looking for

=Percentrank

[Guest Agteros]

 

I can't see anything wrong with the formula. What is it doing that you don't want it to do?

 

 

 

It will subtract the value in B2 from G6' date=' but if you copy this formula to another cell, it will always subtract the value in B2, while the other cell reference will move relative to the original cell's position (as if that makes any sense).

 

 

 

Post what you need it to do... (or what it's not doing).

 

 

 

Cheers,

 

 

 

Andrew[/quote']

 

take the $ signs out.They indicate that the refeference to the cell should not change when copying the formula... =G6-B2

 

[XTC OKE]

nope aint percentrank but thanks

[XTC OKE]

the dollar signs is needed, im copying it like 400times

[XTC OKE]

ok new question