Is it possible to have a formula give a total word count in a given range excluding duplicates? I can only figure out how to count spaces. please see the example below A1:B3
Based on that example I would like the formula to display 4. for the life of me I cant seem to get this right. I would like to stay away from vba to keep compatibility between pc and mobile. the final sheet will have 20 rows if that matters. I really hope this is possible.
Thanks for taking the time to read!
one two | 12375 |
three | one |
12375 | two |
Based on that example I would like the formula to display 4. for the life of me I cant seem to get this right. I would like to stay away from vba to keep compatibility between pc and mobile. the final sheet will have 20 rows if that matters. I really hope this is possible.
Thanks for taking the time to read!