Yogi, your formula is also useful to me, thank you very much for helping!
many thanks to all
Hi LMF and Ricky:On 2002-04-13 14:18, Ricky Morris wrote:
assuming that the data you're working with is in a range named "Data" try the following:
in cell F1 enter "Round"
in cell F3 enter "1"
in cell G1 enter "Round"
in cell G3 enter "2"
# of people finished in round 1 is:
=DMAX(Data,"Pos",F1:F2)
# of people finished in round 2 is:
=DMAX(Data,"Pos",G1:G2)
If you wanted to use the D-functions ... then in cell F1 put Round; in cell G1 put Pos; in cell F2 put 1, in cell G2 put <>Incompleted
then the formula:
=DCOUNT(A1:B25,"round",F1:G2) will give 10; and when you put in cell F2 the value 2, it will give result for Round 2 of 8
Like this thread? Share it with others