You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter Pasadu
- Start date

Take that as an inspiration, add the other conditions, and you're good.

The purpose of a forum is NOT to do the work for you but help you understand and learn.

You're right sir, I have tried it over and over but without getting it. I also tried Min(If(Mod(Column(E3:M3),2=0,E3:M3,"")) without getting the answer.

Take that as an inspiration, add the other conditions, and you're good.

The purpose of a forum is NOT to do the work for you but help you understand and learn.

With the aggregate function,I tried adding AND and ISTEXT functions but still couldn't find a way out.

I still appreciate your response though.

Thank you.

Thank you sir but I am getting a different results. I want to use theDo you have MINIFS function in your Excel "Microsoft Professional Plus 2016" version?

Or,

Try the following formula:

View attachment 81005

Regards

But my computer returns the expected result in cell H8?Thank you sir but I am getting a different results. I want to use theaggregateformula though. Thank You. No i don't have MINIFS function please.

View attachment 81006

Please check your cell H8 "Cell format," and ensure it is in: "General" setting

Sir, I still have 0.02. All the same, thank you and i appreciate your time and effort.But my computer returns the expected result in cell H8?

Please check your cell H8 "Cell format," and ensure it is in: "General" setting

View attachment 81008

Code:

```
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"KANS"}, "Attribute", "Value"),
#"Filtered Rows" = Table.SelectRows(#"Unpivoted Other Columns", each ([Attribute] = "OMA" or [Attribute] = "SKYBLUE WAVES")),
#"Grouped Rows" = Table.Group(#"Filtered Rows", {"KANS"}, {{"Min", each List.Min([Value]), type number}}),
#"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"KANS"})
in
#"Removed Columns"
```

Sir, I still have 0.02. All the same, thank you and i appreciate your time and effort.

View attachment 81010

Hi,

1] Your formula: =AGGREGATE(15,6,E3:M3/(E2:M2<>"USD")/(E2:M2<>"% Price Difference"),1)

>> criteria of "Price Difference" is with 1 space in between

2] My formula: =AGGREGATE(15,6,E3:M3/(E2:M2<>"USD")/(E2:M2<>"% Price Difference"),1)

>> criteria of "Price Difference" is with 2 spaces in between

And,

Your source data E2:M2, "Price Difference" is with 2 spaces in between, please check!

I am sorry for the oversight. I appreciate your time and correction. I checked it, and corrected it, and now it works perfectly. Thank you so much sir.Hi,

1] Your formula: =AGGREGATE(15,6,E3:M3/(E2:M2<>"USD")/(E2:M2<>"% Price Difference"),1)

>> criteria of "Price Difference" is with 1 space in between

2] My formula: =AGGREGATE(15,6,E3:M3/(E2:M2<>"USD")/(E2:M2<>"% Price Difference"),1)

>> criteria of "Price Difference" is with 2 spaces in between

And,

Your source data E2:M2, "Price Difference" is with 2 spaces in between, please check!

View attachment 81014

Let me attend to it please. This escaped me after the answer I received before your comment, solved the problem.

Will get back to you asap

Im sorry for the late reply sir, i really apologize for it.

Code:`let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"KANS"}, "Attribute", "Value"), #"Filtered Rows" = Table.SelectRows(#"Unpivoted Other Columns", each ([Attribute] = "OMA" or [Attribute] = "SKYBLUE WAVES")), #"Grouped Rows" = Table.Group(#"Filtered Rows", {"KANS"}, {{"Min", each List.Min([Value]), type number}}), #"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"KANS"}) in #"Removed Columns"`

I have tested it, but i am confused as to how to generate the answer.

Will the answer show in a cell or I will have to go to Power query to locate the answer?