Try this:
=FILTER(Tabelle1[Customer];(Tabelle1[Revenue Start]>=Tabelle3!A4)*(Tabelle1[Revenue End]<=Tabelle3!B4)*(Tabelle1[Owner]=WENN(Tabelle3!D4<>"";Tabelle3!D4;"*"));"")
Not tested, as your sample file is not complete enough to allow testing (no source data provided).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
That works when I have Input in my D4 Owner Field but not when it is empty.
Do you mind giving me a short explanation about the last part?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks