+ Reply to Thread
Results 1 to 3 of 3

Compare and give output

  1. #1
    Registered User
    Join Date
    04-05-2007
    Posts
    3

    Compare and give output

    I need help having excel find the lowest output from several items in a column.

    example:
    Column A Column B
    Product X $1.00
    Product X $2.00
    Product X $3.00
    Product Z $5.00
    Product Z $4.00

    I need it to give me
    Product X $1.00
    Product Z $4.00

    Thanks

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Use an array formula like this one:

    =MIN(IF($A$1:$A$5="x",$B$1:$B$5)) for x

    =MIN(IF($A$1:$A$5="z",$B$1:$B$5)) for z

    Keep in mind, both of these are array formulas. You must press CTRL+SHIFT+ENTER after entry

  3. #3
    Registered User
    Join Date
    04-05-2007
    Posts
    3
    Thanks- How about if I have many products in column A each w/ different values in column B?

    Can a formula be written to recognize each change in column A?

+ 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