Forum Discussion

mrxware's avatar
mrxware
Copper Contributor
Dec 27, 2022
Solved

Combining 2 Formulas to Check and Return Value

Need Help  We have Columns contains numeric value , I need Excel Formula to copy the same cell if only the Digit Number 9 & 8 from right to left equal (50, 52, 54, 55, 56 or 58), other wise return N...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 28, 2022

Alternatively with 2021 or 365:

=IF(ISNUMBER(XMATCH(MID(A1:A19,LEN(A1:A19)-8,2),{"50","52","54","55","56","58"})), A1:A19, "null")

 

Hi MY (^0 isn't required in your nice MMULT option)

mrxware's avatar
mrxware
Copper Contributor
Dec 29, 2022
Appreciate Your Help

Resources