+ Reply to Thread
Results 1 to 3 of 3

Showing Mininum $ for items

  1. #1
    woody
    Guest

    Showing Mininum $ for items

    I have imported a cost item list from quickbooks. I have many items and I am
    trying to find a way to get the minimum for each item without going through
    each item. The items are in colum A and the Cost is in colum H. I would
    like to put the minimum cost in colum J. Is thsi possible in excel 97? If
    so, How???

  2. #2
    Anne Troy
    Guest

    Re: Showing Mininum $ for items

    How is the minimum cost calculated?
    ************
    Anne Troy
    www.OfficeArticles.com

    "woody" <woody@discussions.microsoft.com> wrote in message
    news:6024C2D6-5D77-417B-BBC7-389557C74A58@microsoft.com...
    >I have imported a cost item list from quickbooks. I have many items and I
    >am
    > trying to find a way to get the minimum for each item without going
    > through
    > each item. The items are in colum A and the Cost is in colum H. I would
    > like to put the minimum cost in colum J. Is thsi possible in excel 97?
    > If
    > so, How???




  3. #3
    Bob Phillips
    Guest

    Re: Showing Mininum $ for items

    =MIN(IF(A2:A200="Material",C2:C200))

    as an array formula, so commit with Ctrl-Shift-Enter

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "woody" <woody@discussions.microsoft.com> wrote in message
    news:6024C2D6-5D77-417B-BBC7-389557C74A58@microsoft.com...
    > I have imported a cost item list from quickbooks. I have many items and I

    am
    > trying to find a way to get the minimum for each item without going

    through
    > each item. The items are in colum A and the Cost is in colum H. I would
    > like to put the minimum cost in colum J. Is thsi possible in excel 97?

    If
    > so, How???




+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1