+ Reply to Thread
Results 1 to 5 of 5

Summary for list

  1. 06-23-2010, 12:26 AM #1
    sureshp.rpt
    sureshp.rpt is offline
    Registered User
    Join Date
    06-23-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    13

    Post Summary for list

    Hello ,
    I want the summary for below list enclosed with the following result. Ex: If the So no have the both TIme "NOTD " & " OTD" . I want in the summary for so no. if the time contain NOTD against the order , the order is NOTD. If NOTD not there , the order is OTD. what function used for ths? KIndly help me

    SO NO TIME
    100000011E NOTD
    100000011L OTD
    100000012E NOTD
    100000012L OTD
    100000013L NOTD
    100000013L OTD
    100000013L OTD
    100000013L OTD
    100000014E NOTD
    100000014E NOTD
    100000014E NOTD
    100000014E NOTD
    100000014E NOTD
    100000014E NOTD
    100000014E NOTD
    100000014E NOTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014E OTD
    100000014L OTD
    100000014L OTD
    100000015L OTD
    Reply With QuoteRegister To Reply
  2. 06-23-2010, 03:55 AM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Summary for list

    what?????? post a workbook
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 06-24-2010, 06:43 AM #3
    sureshp.rpt
    sureshp.rpt is offline
    Registered User
    Join Date
    06-23-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Summary for list

    Hi , i enclosed the workbook with some example data & results also.

    Thanks in advance

    regards
    Suresh
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-24-2010, 07:17 AM #4
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Summary for list

    I must confess, I don't see what you want to do, but my best guess is that you can start a pivot table. See attached

    cheers
    Attached Files Attached Files
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  5. 06-24-2010, 07:27 AM #5
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Summary for list

    ok third time lucky having alot of trouble posting today see attached with some methods
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1