Hello,
I am trying to match sales records (day + product) and return client, but some sales overlap.
This returns me the same client for two different entries.
I am sure there is some formula to avoid such thing or to return unique value. Although I found some array formulas on Google wasn't able to apply for my kind of data.
I have attached Excel file to clear things up.
I am using Excel 2010
Thanks for help
edited. I'm really sorry, uploaded wrong file . Now it's ok
Bookmarks