Database-esq Question
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Database-esq Question

  1. #1
    Guest

    Default

     
    Hi all,
    I have a 'table' that looks something like..
    Name Code Sales Comment
    ... x yyy ......
    ... x yyy ......

    Need to produce a report that looks something like...

    Code: X Total Sales:$YYY
    Code: Y Total Sales:$ZZZ

    The data is kind of big, roughly 30 Megs
    Can't use SUMIF etc. because the conditions are a lot more complicated than illustrated here.

    Tried DCOUNTA, DSUM but found out the criteria gets too weird..
    There are roughly 30 different codes.

    What's the best way to do it? Trying to find ideas... Thanks guys

    Help!!

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You're post is fairly vague but it smells like an array formula (or control-shift-enter (cse) formula).

    Here's some examples of how they work:

    http://www.j-walk.com/ss/excel/tips/tip74.htm

    Remember you enter the formula like a normal one, but, instead of pressing enter, you press control-shift & enter at the same time.

    HTH. Cheers,

    Nate

  3. #3
    Guest

    Default

    Thanks, exactly what I am looking for... Guess I can't phrase my questions properly.. Cheers

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Glad to hear the examples looked good. Your example was great if your wanted a general answer, all's well that ends well eh. Have a good one.

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-02-28 19:39 ]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-28 19:39, NateO wrote:
    Glad to hear the examples looked good. Your example was great if your wanted a general answer, all's well that ends well eh. Have a good one.

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-02-28 19:39 ]
    Also, for a non-array approach, try searchign this board for "SUMIFs with multiple criteria" (SUMPRODUCT), which'll change your life via-a-vis extracting numerical info from a large database

    HTH
    Chris

    ps Nate : Q) what goes "clip clop, clip clop, BANG !, clip clop" ?

    (Friday evening joke...)

    A) an Amish drive-by shooting



    [ This Message was edited by: Chris Davison on 2002-03-01 12:41 ]

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