AntiFilterValues( ListA; ListB )
Rate this function: Average rating: 3.8 (9 votes) Discuss this Custom Function
Bruce Robertson, Concise Design
http://concise-design.com
Return values only contained in ListA
Sample Input:
AntiFilterValues( "1¶2¶3¶4¶1¶"; "1¶3")
Assuming you have archived a list of record ID values for a table:
AntiFilter(OldRecIDlist; newRecIDList) |
|
Sample Output:
2
4
List of deleted records |
|
Description:
Updated 5/3/2009 - correct results if listB is empty (returns ListA)
Updated 10/13/2008 - now correctly fully matches list item
Another custom function that does the opposite of the built-in FilterValues function. It returns the list of items that are only contained in ListA.
This one has high performance across tens of thousands of records and in my testing, beat performance of some of the compile and calculate list methods.
Deals with recursion limit by using a hardwired multiline calculation, and by dwindling the list.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
Bin2Hex ( binary ) |
| |
(Sat, Mar 13, 10:08pm) |
| 2. |
SlideView (text) |
| |
(Sat, Mar 13, 8:40pm) |
| 3. |
HashFNV1a64 ( text ; empty ) |
| |
(Sat, Mar 13, 6:23pm) |
| 4. |
HashFNV1a32 ( text ; empty ) |
| |
(Sat, Mar 13, 5:55pm) |
| 5. |
XORbin( bin0 ; bin1 ; "" ) |
| |
(Sat, Mar 13, 4:35pm) |
| 6. |
cfMatch ( value_to_test; match_Value; match_operator ) |
| |
(Thu, Mar 11, 10:45pm) |
| 7. |
DeleteMiddleText ( Value ; StringStart ; StringEnd ) |
| |
(Wed, Mar 10, 8:27am) |
| 8. |
Codify( theText; code_option ) |
| |
(Sun, Mar 07, 8:17pm) |
 |
|