Need VBA code to Match 5 columns and mark unchanged/changed in next cell

[billigee]

Dear All,

I am working with a sheet where there is a cost of products for 5 months from column A to E, I want to check if there is any change in price in any month then it should mention CHANGED in column F or UNCHANGED in column F

the criteria is TRUE figure (UNCHANGED) is

if amount in all 5 columns is same
if amount of 1 column is blank or zero and other 4 column are same
if amount of more than 1 column is blank or zero and rest of columns are same

Then the result should be UNCHANGED

otherwise it should mentioned CHANGED

to make it more clear see snapshot

Thankyou

 

[Micron]

Thank you. Version issues regarding formulae shouldn't be a problem for me as my old brain has no desire to comprehend what most of them do!

 

[Peter_SSs]

Which is it that you're saying can't be used in 2016 - the proposed formula or the udf?

LET Function in 2016

In fact, in my original proposed formula, it would be both the LET and FILTER functions that cannot be used in Excel 2016.

I will check it in my 2016 version and hope it will work,

If it doesn't work, then it won't be because the functions are not available since MAX has been around "forever" and AGGREGATE since Excel 2010.

 

[billigee]

In fact, in my original proposed formula, it would be both the LET and FILTER functions that cannot be used in Excel 2016.



If it doesn't work, then it won't be because the functions are not available since MAX has been around "forever" and AGGREGATE since Excel 2010.

Max and Aggregate formula is working
Thankyou

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.