Best way to identify unique text across 9 repeating text line items across and count
I am currently exploring the best way to identify unique text and count the unique text matches across 9 text line items by one line item that counts based on unique names:
It would possible with a monster of a formula using multiple IFs but this not necessarily best practice.
For example if I have line items:
Name 1 - Text 1
Name 2 - Text 2
Name 3 - Text 3
Name 4 - Text 4
Name 5 - Text 5
Name 6 - Text 6
Name 7 - Text 7
Name 8 - Text 2
Name 9 - Text 9
Calculation line item:
Unique Names Count - I would expect the result to be 8 (based on a formula analyzing Name 1 to Name 9)
Can anyone accept this challenge and help!
I look forward to hearing from you.