Home |
Search |
Today's Posts |
#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
|
|||
|
|||
Showing Mininum $ for items
How is the minimum cost calculated?
************ Anne Troy www.OfficeArticles.com "woody" wrote in message ... 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
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns showing up as thin vertical lines | Excel Discussion (Misc queries) | |||
Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
formula in cell not showing result | Excel Worksheet Functions | |||
Bar showing value for missing data | Charts and Charting in Excel |