split rank in order when certain criteria is met

[RPimentel]

I run a class that ranks everyone but there is 2 different groups that have to be ranked. There is about 15 sheets and on 1 of those sheets I would like to separate the 2 groups and rank them in order. Here is what I have so far:

Because of ties I used this formula
=(COUNTIF($Y$2:Y2,Y2)-1)*0.00001+Y2

Then I ranked the 2 groups each in 1 column using this:
=COUNTIFS($B:$B,">"&$B2,$G:$G,G2)+COUNTIFS($B$2:$B2,$B2,$G$2:$G2,$G2)

so what I need to do is rank A column when G column is 1 on Sheet1!A then rank A column when G column is 2 on Sheet1!E

right now it looks like this
A G

2 1
4 2
7 1
8 1
3 1
1 2
3 2
1 1
6 1
5 1
2 2
4 1

 

[RPimentel]

I solved it by adding 2 rows and adding an if statement first to find out if G column is a 1 or 2 so looks like this:
=IF(G2=1,(COUNTIF($Y$2:Y2,Y2)-1)*0.00001+Y2,"")
AND ADDING
=IF(G2=2,(COUNTIF($Y$2:Y2,Y2)-1)*0.00001+Y2,"")
then I can index match in Sheet1!A and Sheet1!e with the respective rows. Add an iferror( ,"") to down the page in ranking