Hello,
I've been trying for days to accomplish the following.
I included a simplified excel. The original contains more columns and rows in the data sheet.
In sheet "output": there needs to be "yes" in column B when in the Data-sheet a username (Data-sheet) for the Site/customer in column A contains "comp".
I tried a lot of different things and I can make a yes/no list per customer. But not just one simple "yes" in 1 field.
Another solution would be to give me a list of all sites/customers where username contains "comp".
The Data in te excel changes frequently. So the formula would have to very dynamic.
Maybe I'm making it to complicated because I've been looking at the problem for too long.
I hope this makes sense and someone can help me.
thx!
Bookmarks