Define FirstRow & LastRow in a subset of data

Can you define FirstRow and LastRow functions define a set or group of number? The start and end of a set so in sampledata sheet for column A for numbers = 1 FirstRow would equal A2 and lastRow equal to A8. That would allow me to then know the range of numbers for my PercentRank function.

I have been trying without success. My code represents where I am going but if you have other code please let me know.

This code is attemping to define a values of a group which all have a number 1 as its value and work out the percent rank of values in Column C and return it to column D.

Please Login or Register  to view this content.

What I am trying to acheive is column D in the Sampledata workbook.

So that PERCENTRANK(Cells("FirstRow, C": "LastRow, C", "Cellref needing loop")) when column A equals 1 would translate to

Please Login or Register  to view this content.

And then repeat for each number in column A.

Please Login or Register  to view this content.

The PercentRank function doesn't work. I am getting an error sub or functionundefined.

The help menu has the function as

Please Login or Register  to view this content.

But what expression should be in front of the percent rank.

It doesn't work as written as it invalid, I just changed what you had to show you the syntax on that part.

DO you want to insert the formula into the cell, or do you want to evaluate that function?

Well in the sampledata spreadsheet the answer to evaluate for each cell would go in column D. I then want to repeat for each number in column A(Each group).

I am trying to find percentrank for each individual per class(listed by number in spreashseet).

Please Login or Register  to view this content.