Hi everyone,
Thanks in advance for the help. I am trying to rank a column based on specific criteria. I have it working up to a point. See below. As you can see I am ranking A, B, C, etc. based on the column that starts with 23.91. The column to the right of the B works fine, it is ranking everything based on the letter. =IF($O3=" "," ",SUMPRODUCT((O3=$O$3:$O$2000)*(J3<$J$3:$J$2000))+1). Column O is the letters, and J is 23.91. I then tried to rank just by the letters and don't want to include the dollar amounts for any other letter but this formula =IF($O3="A",RANK.EQ(P3,$P$3:$P$703,1)," ") is including them. As you can see below 22.55 should be ranked 2 and 22.33 should be and so on but it's not. What can I do to get it the way I need?
Thanks in advance for the help. I am trying to rank a column based on specific criteria. I have it working up to a point. See below. As you can see I am ranking A, B, C, etc. based on the column that starts with 23.91. The column to the right of the B works fine, it is ranking everything based on the letter. =IF($O3=" "," ",SUMPRODUCT((O3=$O$3:$O$2000)*(J3<$J$3:$J$2000))+1). Column O is the letters, and J is 23.91. I then tried to rank just by the letters and don't want to include the dollar amounts for any other letter but this formula =IF($O3="A",RANK.EQ(P3,$P$3:$P$703,1)," ") is including them. As you can see below 22.55 should be ranked 2 and 22.33 should be and so on but it's not. What can I do to get it the way I need?