Hello,
I have a list of Customers like this in a column:
A
John
James
Eric
Steve
John
Eric
Wendy
Wendy
I want it to return their name once only by using a formula
John
James
Eric
Steve
Wendy
This is so we can see if a customer ordered during a specific time period. Other formulas will link to it.
I've done this before, I just can't remember how... I think it was an array but I don't know exactly how it was accomplished.
Thanks!
Bookmarks