Forum Discussion
Extracting table values if values in two columns have identical values in other rows
Hi guys, Can someone please help me with a formula for the following task? I have over 40,000 rows of data in 'Table 1', I've extracted a sample. I need to analyse only cells which con...
Great point.
However, if use XMATCH with binary search it works fast
=LET(
pd, product & "| " & decrement,
u, SORT( UNIQUE(pd,,1) ),
f, FILTER( table, ISNA( XMATCH(pd,u,,2) ) ),
VSTACK( {"ID NUMBER","PRODUCT","DECREMENT","IN USE?"}, f )
)
SergeiBaklan Good tip. The [search_mode] never even crossed my mind when I was running my earlier tests (heavy sigh). This is the perfect situation to implement Binary search for improved performance. Thanks for that.