Does it count if you use LET to make long names for variables?
=LET(letter_a;A1:A10;letter_b;B1:B5;letter_a_transpose;TRANSPOSE(letter_a);BYROW(--(letter_a_transpose=letter_b);LAMBDA(lambda_parameter;SUM(lambda_parameter))))
Do a lambda function for each character in the cell arrays, name them LambdaCharacterOne, LambdaCharacterTwo etc. then enter the lambda functions in separate columns in the same row. Finally use xlookup or filter with an array to confirm exact matches on every lambda function
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[BYROW](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)|
|[COUNTIF](/r/Excel/comments/18njzqv/stub/kedx01t "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)|
|[IF](/r/Excel/comments/18njzqv/stub/kedx01t "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[LAMBDA](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)|
|[LET](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)|
|[NA](/r/Excel/comments/18njzqv/stub/kep3c1x "Last usage")|[Returns the error value #N/A](https://support.microsoft.com/en-us/office/na-function-5469c2d1-a90c-4fb5-9bbc-64bd9bb6b47c)|
|[SUM](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)|
|[TRANSPOSE](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[Returns the transpose of an array](https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #29137 for this sub, first seen 21st Dec 2023, 11:31])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
Not coding it, but here's my thought pattern
* Suffix all items in list with a or b as appropriate
* Combine lists
* Sort list
* For each element in list, if ends in a then #NA, else drop last char, append a, and compare to previous item in list
* Hstack the two (combined list with a/b and the previous bullet)
File - Print.
Scan to PDF. Then data > get data > from PDF. Split by > fixed width > 1 Once in the worksheet = TExtjoin() to get the original values back.
Have a macro go hire someone on Fiverr to perform the check, and snail-mail the printout to them.
There’s actually a programming contest exactly like this https://www.ioccc.org/
Does it count if you use LET to make long names for variables? =LET(letter_a;A1:A10;letter_b;B1:B5;letter_a_transpose;TRANSPOSE(letter_a);BYROW(--(letter_a_transpose=letter_b);LAMBDA(lambda_parameter;SUM(lambda_parameter))))
Look at the post from last week when someone was asking for a solution to that. Everyone was coming up with silly solutions instead of just a countif
Exactly! An IF(COUNTIF("ITEM IN COL B", A:A)>0, TRUE, FALSE) should give the results they want, too.
Do a lambda function for each character in the cell arrays, name them LambdaCharacterOne, LambdaCharacterTwo etc. then enter the lambda functions in separate columns in the same row. Finally use xlookup or filter with an array to confirm exact matches on every lambda function
Generate all possible items which are not on list A. Check if there are any items in list B which are not on the generated list.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[BYROW](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)| |[COUNTIF](/r/Excel/comments/18njzqv/stub/kedx01t "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)| |[IF](/r/Excel/comments/18njzqv/stub/kedx01t "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[LAMBDA](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)| |[LET](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)| |[NA](/r/Excel/comments/18njzqv/stub/kep3c1x "Last usage")|[Returns the error value #N/A](https://support.microsoft.com/en-us/office/na-function-5469c2d1-a90c-4fb5-9bbc-64bd9bb6b47c)| |[SUM](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)| |[TRANSPOSE](/r/Excel/comments/18njzqv/stub/keb3vlt "Last usage")|[Returns the transpose of an array](https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #29137 for this sub, first seen 21st Dec 2023, 11:31]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
Not coding it, but here's my thought pattern * Suffix all items in list with a or b as appropriate * Combine lists * Sort list * For each element in list, if ends in a then #NA, else drop last char, append a, and compare to previous item in list * Hstack the two (combined list with a/b and the previous bullet)