VBA RANK
Thanks, how about looping through the range, like range(D & value) =
WorksheetFunction.Rank(Range("A7"), is this possible? so I can get the top
ten
"OssieMac" wrote:
Not sure that I understand your question but the following examples of VBA
code might put you on the right track.
Range("D1") = WorksheetFunction.Rank(Range("A7"), _
Range("A$7:A$200")) + WorksheetFunction.CountIf(Range("A$7:A7"), _
Range("A7")) - 1
Range("E1") = WorksheetFunction.Min(Range("A$7:A7"))
Range("F1") = WorksheetFunction.Max(Range("A$7:A7"))
--
Regards,
OssieMac
"djdwwoug" wrote:
is there a way that I can make this formula into
VBA code that looks up a given range see below
=RANK(A7,A$7:A$200)+COUNTIF(A$7:A7,A7)-1
and then used VBA the to get the Large and Small values
Thanks
|