Hello friends, Hope all is well.
Please take a look at the attachment.
I would really appreciate it, if someone could assist me with a formula that would:
1. Show unique lookups. i.e. shows all the possible branches.
2. Which are under Mike.
3. Without repetition of branch names.
4. As you can see Mike is in column J and the branches are in column D.
I tried a formula but it kept repeating NY in the 2nd, 3rd, etc, instead I want to see Tx in the 2nd and UT in the 3rd.
Your kind help is truly appreciated! Thanks a lot in advance!
Bookmarks