Does it have to be VBA?
Formula solution
=IF(RANK(A1,A$1:A$7)>5,"",RANK(A1,A$1:A$7))
and copy down
Does it have to be VBA?
Formula solution
=IF(RANK(A1,A$1:A$7)>5,"",RANK(A1,A$1:A$7))
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks