Yeah I thought it had too, it seemed to work on a small test. Maybe the problem is in all my data.
But I'll try and describe what I mean in better detail. Could turn out that the macro already does it, but just want to clarify whether it is/isn't the problem.
So back to the five cells I listed previously. If one was to perform a normal RANK function between them;
U408 - 1st
U208 - 2nd
U8 - 3rd
U808 - 4th
U608 - Ignored
What seems to be happening though is;
U608 is 'Ignored' as in it doesn't get Ranked. (So the cell next to it is blank)
But the formula in the cell V8 say, looks like this; =(.....(RANK(U8,( U8,U208,U408,U608,U808)))) [I've left out the other part of the formula]
As U608 is present in this formula, is it therefore included in the Range which U8 is compared against? Because at the moment all of V8,V208,V408,V608,V808, N/A values are appearing in them.
If this isn't the case,
does your code ignore every type of error value (i.e. REF, NUM etc.)?
I'll try and find a PC and may be able to tell you what I mean better via excel genie.
Thanks,
Alex.