yeah i have 1 column "y" with 46 cells of data in those cells is =RAND()
in column "z" i have cells 1-46 with a random word in them
what =INDEX(Z$4:Z$46,RANK(Y4,Y$4:Y$46)) does is rank the "z" column of names based on the rank of random number that is generated in y
it works fine in excel but does not work at all in QTP
in column "z" i have cells 1-46 with a random word in them
what =INDEX(Z$4:Z$46,RANK(Y4,Y$4:Y$46)) does is rank the "z" column of names based on the rank of random number that is generated in y
it works fine in excel but does not work at all in QTP