# Showing Mininum \$ for items

1. ## 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. ## 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. ## 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???

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

#### 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