An awesome trick to compare 2 Excel ranges and flag the differences 

Creating a magic formula to compare 2 ranges of data for non matching items
00:00 Intro including demo of the end result
01:23 How I built this
05:50 Wrapping it in the LET function
08:00 How to create the MYCOMPARE auto-magical formula
The formula
(IMPORTANT *** RU-vid does not allow me to type ANGLED BRACKETS below so I have type the word DOESNOTEQUAL but you should replace this )
No Let
=HYPERLINK("#"&
TEXTJOIN(",",TRUE,
IF( dblClickRange1 DOESNOTEQUAL dblClickRange2,
ADDRESS( ROW( dblClickRange2 ), COLUMN( dblClickRange2 ) ),
"")
)
)
With LET
=LET(
_Range1, dblClickSelectRange1,
_Range2, dblClickSelectRange2,
HYPERLINK("#"&
TEXTJOIN(", ",TRUE,
IF( _Range1 DOESNOTEQUAL _Range2,
ADDRESS( ROW(_Range2), COLUMN(_Range2) ),"")))
)
Power Query Challenge
• Power Query Table Flip...
Connect with me
wyn.bio.link/
Access Analytic blog: accessanalytic.com.au/blog/

Хобби