• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Require MIN price for each SKU Group

walker.cycling

New Member
Hello

I need to return the MIN price from a list of grouped SKUs.
Each SKU can have between 3 - 12 pack sizes associated with it
Each pack size has an individual and unique price

I need a result where in one column has the SKU and the other column has the MIN price

I have too many to do it manually

See attached sheet. The data in columns A,B,C is an example of my existing data.
The data in columns E,F is the what I need.
 

Attachments

rahulshewale1

Active Member
Hi @walker.cycling ,

See if is it ok ?

Get Unique Sku Name :
H3: Copy Down ( Array Formula : Press Ctrl + Shift + Enter ) Any Version
{=INDEX($A$3:$A$50,MATCH(0,COUNTIF($H$2:H2,$A$3:$A$50),0))}

if you have office 365.
=UNIQUE(A3:A50)


''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Get Min Price :=
I3: Copy Down ( Array Formula : Press Ctrl + Shift + Enter ) Any Version
{=MIN(IF($A$3:$A$50=H3,$C$3:$C$50))}

if you have office 365.
=MINIFS($C$3:$C$50,$A$3:$A$50,H3)
 

Attachments

walker.cycling

New Member
Hi @walker.cycling ,

See if is it ok ?

Get Unique Sku Name :
H3: Copy Down ( Array Formula : Press Ctrl + Shift + Enter ) Any Version
{=INDEX($A$3:$A$50,MATCH(0,COUNTIF($H$2:H2,$A$3:$A$50),0))}

if you have office 365.
=UNIQUE(A3:A50)


''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Get Min Price :=
I3: Copy Down ( Array Formula : Press Ctrl + Shift + Enter ) Any Version
{=MIN(IF($A$3:$A$50=H3,$C$3:$C$50))}

if you have office 365.
=MINIFS($C$3:$C$50,$A$3:$A$50,H3)
Thankyou, we have 365. At first I couldn't get this to work, then after some playing around I managed to but then found my computer couldn't handle the size. I will have a attempt later today
 
Top