can anyone please help me??? - Page 2
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: can anyone please help me???

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Yogi, your formula is also useful to me, thank you very much for helping!



    many thanks to all

  2. #12
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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)
    Hi LMF and Ricky:
    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



    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com