Unanswered: Need Help with Concatenate and Countif
I need your help in calculation a number and value.
The case is-
Column A contains Name
Column B contains Numbers
Now, i need to concatenate A&B and find the unique data of concatenate using countif. How do i do this in single cell using a single formula?