Results 1 to 20 of 30

Thread: Extracting max & min values with a condition

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-09-2007, 10:19 PM #1
    surya prakash
    surya prakash is offline
    VBAX Contributor
    Joined
    Dec 2004
    Posts
    173
    Location

    Extracting max & min values with a condition

    Hi,
    Wondering if it possible to get the maximum, minimum and average values from the table

    Descp Max Min Avg
    A 15 10 12.50
    B 26 21 23.50
    C 35 31 33.00

    Will be thankful for any feedback...

    Table:
    Name Nos
    A 10
    A 11
    A 12
    A 13
    A 14
    A 15
    B 21
    B 22
    B 23
    B 24
    B 25
    B 26
    C 31
    C 32
    C 33
    C 34
    C 35
    Last edited by surya prakash; 05-10-2007 at 12:26 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules