|Apologies, what meant was i need the formula which |
1.- find only the total if the group is XX,XY,XZ accordingly
2.- Rank the data according to ONLY the values which are on XX,XY,XZ accordingly
from my example, i have previously used a formula that has given me all the values according to the groups so fo exapmle cell A2 will have the formula =IF(E2="XY",F2,"")
XY (colum A), XZ (columB) etc... and rows 1,2,3, 4,... etc
what i need is a formula which i can put in A2 which will say, =IF(E2="XY",F2,"") and also Rank the data where it has found values...
does that explain it better??
please refer to the last table for the complete data
A B C D E F
1, XY XZ XX Name Group Total
2, 5 AAB XY 256.22
3, 5 AAC XZ
4, 1 GHAG XX 241835.31