Sajan
Excel Ninja
Challenge Name
-- Calculate the number of unique characters that are common to two strings
Challenge Description
-- This is a formula challenge. As such, only formula submissions are accepted.
-- For two given strings (that may contain any number of characters -- alphabets, numbers, symbols, etc. -- the goal is to determine the number of unique characters that are common to both strings.
-- Each string could be of variable length.
-- Goal is to calculate the count without using any helper cells, names, etc.
Assumptions
-- You may assume a different location for the data range than cell A1 and B1
-- You may not use any helper cells
-- No difference is attributed to upper case and lower case alphabets. i.e. "A" and "a" are considered equivalent.
-- The characters in each string may appear in any order
Sample data and output:
As an example, the string "Ridiculous" and "Simple" have the letters "s", "i" and "l" in common. As such, the expected output will be 3.
Please verify your formulas against the sample output provided
Enjoy!
-Sajan.
-- Calculate the number of unique characters that are common to two strings
Challenge Description
-- This is a formula challenge. As such, only formula submissions are accepted.
-- For two given strings (that may contain any number of characters -- alphabets, numbers, symbols, etc. -- the goal is to determine the number of unique characters that are common to both strings.
-- Each string could be of variable length.
-- Goal is to calculate the count without using any helper cells, names, etc.
Assumptions
-- You may assume a different location for the data range than cell A1 and B1
-- You may not use any helper cells
-- No difference is attributed to upper case and lower case alphabets. i.e. "A" and "a" are considered equivalent.
-- The characters in each string may appear in any order
Sample data and output:
Code:
String1 String2 UniqueCount
Ridiculous Simple 3
Incredible Silly 2
Magic Fun 0
Balloon Children 2
November December 4
January August 2
February January 4
United States India 4
Australia United Kingdom 3
Indomitable submissive 4
Hippopotamus Elephant 4
Formula Challenge 2
Please verify your formulas against the sample output provided
Enjoy!
-Sajan.
Last edited by a moderator: